Meiady leich, owner of Enoudway Fioral, operated a local chain of fiaral shags fach shop han itn own delivery van. Intead of charging a fat delhery fee leleh wartis to set the delivery fee based on the ditarce dniwn to deliver the fiowers. Leigh wants to separate the fiatd and variable portions of her van operatins cotts so that the has a betier idea of how delivenr distance atfects these coura. She has the followirs dafa from the oult seven morthit. Use the blue shaded areas on the LNTERAWS WEAS yab for inputa Aeays aa conlil referencel and fomnulas where apgropriate to recelve fall credit. If your copy/paite from the instruction tab of if you type the numbert in, you will be marked wrone. Reguirements output from the reeression analysis you pertormed using Excel a. Renathe the regression output tab "fEGAESSON" 2. Determine the R-square (use the oulput from she Fxtel regreision) 3 Predict van operating costs at a volume of 16,900 miles aswumine the company would use the dont equabion trom the Ekcel recresslon regard ess of its 8 -iquare: 3. Aeference values calculated in previous requirements as noeded. Saving E Submitting Solutben 1 Save file to desktop. a. Create folder on desktog, and label coMDLITED EvCFL MhOjECT5 2. Hpload and submit your file to be graded. 3. Navieate back to the acthity window - screen where you downioaded the initial spreathheat b. Cick Choose button under step 3, locate the file.youjust saved and click Open c. Cick Upload button under step 3 d. Cick Submit button under step 4 1. Run a regression analysis using data for January through July. Determine the company's cost equation (use the output from the regression analysis you performed using Excel). (Always use cell references and formulas where appropriate to recelve full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) y= 2. Determine the R-square (use the output from the Excel regression). (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) square = 3. Predict van operating costs at a volume of 16,500 miles assuming the company would use the cost equation from the Excel regression regardless of its R-square. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)