# Question: A store wants to predict net profit as a function

A store wants to predict net profit as a function of sales for next year. Historical data for 8 years is given in the table below.

Year Sales (thousands of dollars) Net Profit

1 59 ..................... 5.02 50 ..................... 8.43 51 ..................... 9.54 65 ..................... 8.65 80 ..................... 1.56 85 ..................... -2.17 95 ..................... 1.28 90 ..................... 1.8

(a) Make a scatter diagram for the data, using Sales for the independent variable and Net Profit for the dependent variable. Insert the trend line and add the equation and R2 value to the diagram.

(b) Determine the correlation coefficient. Comment on the value of the correlation coefficient.

(c) Find the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.

(d) Construct an ANOVA table and attach the summary output.

Year Sales (thousands of dollars) Net Profit

1 59 ..................... 5.02 50 ..................... 8.43 51 ..................... 9.54 65 ..................... 8.65 80 ..................... 1.56 85 ..................... -2.17 95 ..................... 1.28 90 ..................... 1.8

(a) Make a scatter diagram for the data, using Sales for the independent variable and Net Profit for the dependent variable. Insert the trend line and add the equation and R2 value to the diagram.

(b) Determine the correlation coefficient. Comment on the value of the correlation coefficient.

(c) Find the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.

(d) Construct an ANOVA table and attach the summary output.

**View Solution:**## Answer to relevant Questions

You and a classmate are assigned a project on which you will receive one combined grade. You each want to receive a good grade, but you also want to avoid hard work. In particular, here is the situation: - If both of you ...Test H0: μ1 ≤ μ2; H1: μ1 > μ2 at α = 0.05, when 1 = 75, 2 = 72, s1 = 3.3, s2 = 2.1, n1= 6, n2= 6. Assume equal variances. Indicate which test you are performing; show the hypotheses, the test statistic and the ...My aunt and I were approaching the same intersection, she from the south and I from the west. She was traveling at a steady speed of 9 miles/hour, while I was approaching the intersection at 50 miles/hour. At a certain ...A building 190 feet tall casts a 30-foot long shadow. If a person stands at the end of the shadow and looks up to the top of the building, what is the angle of the person's eyes to the top of the building (to the nearest ...Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years: The scatter plot of the data above shows seasonality with trend. Hence, a multiple ...Post your question