$($earning Objectives

Download the data file and follow the instruction below.

Submit your excel sheet saved as "LastnameFirstInitial$2.$xslx$"($i$.$e$.$ "AsciS$2.$xslx$")$ by Thursday $5$ pm$.$

o Instructions

Download the data and insert them in a new workbook.

Save as "LastnameFirstInitial$2.$xslx$"($use F$12)$

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 X Y Scatter, insert chart title and axis titles $[$x$=$Weekly Income $($$$),y=$ Food Expenditure $($$$)].$ Insert trend line with its equation and $R$

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.!!!!