Question

In: Math

We consider a population of cars from a given model year. A sample of 24 such...

We consider a population of cars from a given model year. A sample of 24 such cars

has been recently sold. The sale price as a function of the age of the car is in the Excel

file S4.XLSX (Car) in the Excel directory.

a. Try a linear regression and an exponential (non-linear) regression with Excel to

fit these data. Comment your results.

b. Which regression model seems to fit the data better and why?

c. Run the LINEST function in Excel. Provide the result table.

Car sale price
Age (year) Price ($)
1 119400
3 73200
5 51000
2 91800
8 36600
2 102000
3 73800
1 120600
6 42600
7 39600
4 61800
8 31200
5 48600
1 126000
5 52800
3 70200
6 43200
6 53400
7 40800
4 63400
7 36000
8 33000
4 64800
2 93000

Solutions

Expert Solution


Related Solutions

Compute in excel A random sample of six cars from a particular model year had the...
Compute in excel A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below. (i) Using T.INV, find a 90% confidence interval for the population mean of fuel consumption for cars of this model year. Assume the distribution is normal. (Round to 2 digits, since our raw data below are expressed with one digit.) (Show work in space provided.) (ii) Calculate the same interval using CONFIDENCE.T. (Show work...
A sample of 71 observations is selected from a normal population. The sample mean is 24,...
A sample of 71 observations is selected from a normal population. The sample mean is 24, and the population standard deviation is 8. Conduct the following test of hypothesis using the 0.05 significance level. H0 : μ ≤ 23 H1 : μ > 23 a. Is this a one- or two-tailed test? (Click to select)  One-tailed test  Two-tailed test b. What is the decision rule? (Round the final answer to 3 decimal places.) (Click to select)  Reject  Accept  H0 and  (Click to select)  accept  reject  H1 when z >  ....
A sample of 44 observations is selected from a normal population. The sample mean is 24,...
A sample of 44 observations is selected from a normal population. The sample mean is 24, and the population standard deviation is 3. Conduct the following test of hypothesis using the 0.05 significance level. H0: μ ≤ 24 H1: μ > 24 a) Is this a one- or two-tailed test? b) What is the decision rule? c) What is the value of the test statistic? d) What is your decision regarding H0? e) What is the p-value? f) Interpret the...
A sample of 44 observations is selected from a normal population. The sample mean is 24,...
A sample of 44 observations is selected from a normal population. The sample mean is 24, and the population standard deviation is 3. Conduct the following test of hypothesis using the 0.05 significance level. H0: μ ≤ 23 H1: μ > 23 Is this a one- or two-tailed test? One-tailed test Two-tailed test What is the decision rule? Reject H0 when z > 1.645 Reject H0 when z ≤ 1.645 What is the value of the test statistic? (Round your...
A random sample of 6 cars from a particular model year had the following fuel consumption...
A random sample of 6 cars from a particular model year had the following fuel consumption figures (in miles per gallon). Find the 99% confidence interval for the true mean fuel consumption for cars of this model year. Sample data: 20.9, 18.1, 18.5, 21, 20.3, 20.2 find left endpoint & right endpoint.
A random sample of six cars from a particular model year had the following fuel consumption...
A random sample of six cars from a particular model year had the following fuel consumption figures (in miles per gallon). Find the 98% confidence interval for the true mean fuel consumption for cars of this model year. Sample Data 18.6 19.3 19.4 19.8 19.6 19.7 What is the left and right endpoint? Please help
A random sample of six cars from a particular model year had the following fuel consumption...
A random sample of six cars from a particular model year had the following fuel consumption figures ( in miles per gallon). find the 98% confidence interval for the true mean fuel consumption for cars of this model year. Sample Data: 19.3 , 18.5 , 18.4 , 20.9 , 20.7 , 18.7 Left Endpoint _____ Right Endpoint _____
Use Excel to Answer. A random sample of six cars from a particular model year had...
Use Excel to Answer. A random sample of six cars from a particular model year had the fuel consumption figures, measure in miles per gallon, shown below. Using T.INV, find a 90% confidence interval for the population mean of fuel consumption for cars of this model year. Assume the distribution is normal.   (Round to 2 digits, since our raw data below are expressed with one digit.) (Show work in space provided.) (ii) Calculate the same interval using CONFIDENCE.T. (Show work...
Given the following income data from a representative sample of a population in a certain year,...
Given the following income data from a representative sample of a population in a certain year, what is its Gini index? Person Income Person Income Person Income 1 30 6 400 11 1700 2 70 7 550 12 2000 3 140 8 1100 13 3000 4 210 9 1200 14 5000 5 300 10 1450 15 8000 A. 0.34 B. 0.44 C. 0.57 D. 0.60 E. 0.76
Consider a random sample of 15 cars of the same model. Assume that the gas mileage...
Consider a random sample of 15 cars of the same model. Assume that the gas mileage for the population is normally distributed with a standard deviation of 5.2 miles per gallon. Calculate a 90% confidence interval for the mean, given a sample mean of 26.7 miles per gallon.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT