Please explain, step by step, do not simply cut and paste others response. I do not understand how to compute and determine the regression statistics in excel. please show each step for DF$,$ SS$,$ MS$,$ F and significance F$.$ orders, on average, must Iviarket $$nyme receIve eacn or $$U weeks next season to break even?

$10-37$ High$-$low method; regression analysis. $($CIMA$,$ adapted$)$ Amy Mendenhall, sales manager of Fitzsimmons Arenas, is checking to see if there is any relationship between promotional costs and ticket revenues at the sports stadium. She obtains the following data for the past $9$ months:

$\backslash$table$[[$Month$,$Ticket Revenues,Promotional Costs$],[$April$,$$$220,000,$$$55,000],[$May$,290,000,68,000],[$June$,340,000,83,000],[$July$,500,000,93,000],[$August$,450,000,103,000],[$September$,470,000,113,000],[$October$,560,000,123,000],[$November$,690,000,183,000],[$December$,756,500,200,000]]$

She estimates the following regression equation:

Ticket revenues $=$$$39,502+($$$3\mathrm{.}60$ Promotional costs $)$

Plot the relationship between promotional costs and ticket revenues. Also draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line. Use the high$-$low method to compute the function relating promotional costs and revenues.

Using $($a$)$ the regression equation and $($b$)$ the high$-$low equation, what is the increase in revenues for

each $$10,000$ spent on promotional costs within the relevant range? Which method should Amy use to

predict the effect of promotional costs on ticket revenues? Explain briefly.