Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello I have an excel statistics question and need help inputting the data on the instructions of this assignment. I have attached three images of
Hello I have an excel statistics question and need help inputting the data on the instructions of this assignment. I have attached three images of the data off excel. I am having trouble understanding the directions of the assignment.
- Align data to Center and change data titles to x=Weekly Income ($), y=Food Expenditure ($). - Find Descriptive Statistics using Data Analysis Toolbar. - Estimate Moving Average (Interva|=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 (35)]. 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 Exp" - Calculate predicted food expenditure when income is $750 using the regression table in your new tabStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started