Assignment No.3 The Toyota Corolla is one of the best-selling cars in Pakistan. The cost of a previously owned Corolla d

[answerhappygod]

Assignment No.3
The Toyota Corolla is one of the best-selling cars in Pakistan.
The cost of a previously owned Corolla depends on many factors,
including the model year, mileage, and condition. To investigate
the relationship between the car’s mileage and the sales price for
Corolla’s, the following data show the mileage and sale price for
19 sales:
Kilo Meters (1000s)
Price
(Rs.1000s)
22
16.2
29
16.0
36
13.8
47
11.5
63
12.5
77
12.9
73
11.2
87
13.0
92
11.8
101
10.8
110
8.3
28
12.5
59
11.1
68
15.0
68
12.2
91
13.0
42
15.6
65
12.7
110
8.3
You are required to:
This assignment is of 05 marks and should be solved
using excel. Please show complete workings. The deadline to submit
is August 28, 2021.