The following information is available regarding the total repair costs of Alexander Design Company for six months of 2022:   Using the least-square regression analysis on Excel, construct a cost formula. Run a regression analysis on the data above and provide your response to the following three questions. Round decimals to the nearest tenth (i.e, two decimal points).  (1) Provide the regression output and construct a cost model.  (2) According to the cost model, what is the estimated total fixed cost? (3) According to the cost model, what is the estimated variable cost per unit?

2. The table below lists the annual land-line phone cost per costumer: Year 2012 2013 2014 2015 Cost ($) a. 692 610 Find a linear regression model for this data b. Interpret the slope of the model 580 C. Predict the annual land-line phone cost per customer in 2022 495 2016 434

The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ý = 22.525 + 0.325x, where x = price ($) and y overall score. %3D Brand Price ($) Score 180 78 B. 150 71 C 95 59 70 54 E 70 40 35 28 (a) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) SST SSR %3D SSE = (b) Compute the coefficient of determination . (Round your answer to three decimal places.) 1 = Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) O The least squares line provided a good fit as a large proportion of the variability in y has been explained by the least squares line. O The least squares line did not provide a good fit as a large proportion of the variability in y…

Refer to the data set: x -1 1 -2 3 0 2 y 9 2 15 1 4 1.5 Part a: Make a scatterplot and determine which type of model best fits the data.Part b: Find the regression equation, round decimals to one place.Part c: Use the equation from Part b to determine y when x = 5.