ges es labus izzes dules ice 365 opto Video urse Ratings Learning Objectives A+ Download the data file and follow the instruction below. Submit your excel sheet saved as "LastnameFirstInitial2.xslx" (i.e. "AsciS2.xslx") by Thursday 5 pm. Instructions - Download the data and insert them in a new workbook. - Save as "LastnameFirstInitial2.xslx" (use F12) - Align data to Center and change data titles to y=Food Expenditure ($), x=Weekly Income ($). - Find Descriptive Statistics using Data Analysis Toolbar. Estimate Moving Average (Interval=4) for each variable using Data Analysis Toolbar. - Create the moving average carts using Chart Output option in the dialog box (Check the boxes for "Chart Output and Standard Errors"). - Name the worksheet tab as "Moving averages." - Open a new worksheet tab and copy/paste data to the new tab. - Plot the data using XY Scatter, insert chart title and axis titles [x=Weekly Income ($), y=Food Expenditure ($)]. Insert trend line with its equation and R-square. - Insert Linear Trend Line to Predicted Y. Insert the equation to the chart. -Create a new worksheet tab called "Predicted Food Expenditure" - Calculate predicted food expenditure when income is $750 using the regression table in your new tab. - Save your workbook and submit it to Canvas !!!!- all tables/graphs should be formatted nicely!!!!!! X 57 258 56 299 83 301 67 368 65 394 111 420 81 434 72 443 104 501 76 528 123 535 112 562 84 571 120 593 97 600 104 651 82 666 122 669 131 700 97 717 136 726 153 728 146 792 137 827 205 828 160 875 174 909 158 910 177 921 209 926 181 967 223 979 160 1003 190 1009 214 1041 194 1052 224 1061 211 1075 242 1110 235 1125