Please answer a through d$.$ Spreadsheet is located on the left side.

Delete this text then place your Simple c Television Advertising 2 3 6 2 3 Weekly Gross Revenue (1 ooos) 97 91 96 93 95 95 95 94 Newspaper Advertising ($10009) .A$1000s) 5 2 5 3 25 3 Predicted Revenue (Part D) 52 Formula for Predicted Revenue Sheetl 18 2 18 28 23 42 28 38 Feedback tc h%crcszft Delete 100% Te aner of Shonme gove Theaters, Inc., would Eke to medd weeWy gross as a functon of advetttsng expenditures. Htstoncal data ft' a sarrde eght weeks are entered nto the Microsoft Ex.' OnIne file below. use the XL"ner TooiPak to peHorm your revessoo ana'yss In the desj;nated areas of the spreadsheet. to a recent change pcrosch you need to open the XLMner Toohk add-in maruay from the home ribbon. SgensSqt of Tcoa.k a. Develop an estimated regressjcn equ*oo wth the amount of tetevson advertsng as the independent venaSe (to 2 decma;s). b. De an estnated regtewcn both te:eostn dverte; and newspet "we-ten; as the undepeet arues (t: 2 decmSs). c, Is the estrnated re;resson equation coeff:sert for herttszn; expendtures the same part (a) and pat d. Prek ;mss revenue then SS,2 thwsarZ spent "etsn; S3E thugnd s {to 2 decumasF thsands Page I ot 1 0 words (S Accessibility: Investigate