Please Help!! Not sure why I got those questions wrong

Date for question:

https://docs.google.com/spreadsheets/d/1Utkck9K9o5d3hg02DZjQ1RE4pH6Zel9JBDUvoGhMVjI/edit?usp=sharing

Part A) options: For the first 3 drop downs: (Remains the same, Increase Sharply, Decreases Sharply.) Last drop down: (2nd order polynomial, 3rd order polynomial, 4th order polynomial, reciprocal transformation, logarithmic transformation)

*I have provided everything I have been given*

Cost Analysis in the Technology Industry: A subsidiary of Elektra Electronics has developed new software that allows Windows-based personal computers to run all Apple (i.e., Mac, iPhone, iPad, etc.) and Android applications. Elektra has collected preliminary data on the weekly total cost of producing the new product at a number of different levels of production. Cost data are available in the worksheet entitled "Software Cost". a) Generate a scatterplot in order to understand the nature of the relationship between weekly quantity produced and weekly total cost. Use this information to complete the statements below. According to the scatterplot, weekly total cost remains the same a x at rst, then it increases sharply a x for a while, and then it begins to levels off a x , as the quantity produced increases. There appears to be 2 J bend(s) or curve(s) in the data which suggests that a 4th order polynomial a x regression model is appropriate. b) Use the data to fit three separate regression models. For the first model, fit the 2nd order polynomial regression model to predict weekly total cost. For the second model, t the 3rd order polynomial regression model to predict weekly total cost. For the third model, fit the 4th order polynomial regression model to predict weekly total cost. Provide summary measures for each model separately in the table below. (Enter your R2 values as percents to two decimal places and enter your standard errors to three decimal places.) Model R2 R3,,- s,3 Second-Order Model 85.28 J % 85.05 I % 83.737 x Third-Order Model 90.84 x 17/0 90.63 x 0/0 66.305 x Fourth-Order Model 90.86 x 17/0 90.56 x 0/0 66.525 x According to your analysis so far, summarize your results. According to your analysis so far, summarize your results. A According to Rid], the fourth-order model is clearly superior to either the second or third-order models. A According to Rgdj, the third-order model is clearly superior to either the second or fourth-order models. A According to Rid], the fourth-order model is clearly worse than either the second or third-order models, however, results are not so clear concerning whether the second or third-order model is best. A According to Rid], the second-order model is clearly superior to either the third or fourth-order models. A According to Rid], the third-order model is clearly worse than either the second or fourth-order models, however, results are not so clear concerning whether the second or fourth-order model is best. 0 According to Rid], the second-order model is clearly worse than either the third or fourth-order models, however, results are not so clear concerning whether the third or fourth-order model is best. c) Perform the appropriate statistical test to test whether the fourth-order model explains a statistically signicant amount of variation in total weekly cost above and beyond of that explained by the third-order model. Use a 5% significance level. State the appropriate test statistic name, degrees of freedom, test statistic value, and the associated p-value (Enter your degrees of freedom as a whole number, the test statistic value to three decimal places, and the p-value to four decimal places). ,_, 'q (126 x )= -o.410 x ,p = 'q .6827 x State your decision. d) Regardless of your results above, assume that the third-order model is best. Based on this estimated total cost function, provide the estimated marginal total cost function (Enter all function coefficients to four decimal places). e) Compute the following quantities WITHOUT any intermediate rounding. In other words, do NOT use the rounded version of the function you reported above in part d. Instead, use the one stored in your EXCEL worksheet. Enter your answers to two decimal places. How quickly is the weekly total cost increasing when the level of production is 125 units per week? dollars per unit How quickly is the weekly total cost increasing when the level of production is 400 units per week? dollars per unit How quickly is the weekly total cost increasing when the level of production is 675 units per week? dollars per unit