The worksheet contains data the accords and camrys including the prices
(Hint: before you do this, review your prior estimates of mean prices. You can provide a copy of your regression output within this file or indicate its location in your Excel file). (4 points)
Based on the regression, interpret the following parameter estimates:
ii. Calculate the test statistic? Write the mathematical expression clearly. (2 points)
iii. What is the decision rule? What do you conclude? Write the complete decision statement. (4 points)
You are assuming that price depends upon additional predictor or independent variables!
a. Wait!! Treatment is a categorical variable. In the Excel worksheet “Q1 – Prices for Regression,” it has been numerically coded: Field = 1, KFC = 2, and PiP = 3. Can you include this numeric variable in your model? Explain – why or why not? How can you include these treatment effects? (4 points)
i. What is the hypothesis you tested? Write the mathematical expression (2 points)
ii. What is the critical value for the test? Use α = 0.05. (2 points)
h. Are there significant differences in tree prices across the different treatments, holding tree height and caliper constant? Specifically, address the following questions using your results:
i. What is the difference between the prices of Field and PiP trees? (2 points)
j. Write a sentence interpreting your 99% confidence interval estimate. (2 points)