Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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.

image text in transcribedimage text in transcribedimage text in transcribed
- 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 tab

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Complex Variables And Applications

Authors: James Brown, Ruel Churchill

9th Edition

0073530859, 9780073530857

More Books

Students also viewed these Mathematics questions

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago

Question

1. I try to create an image of the message

Answered: 1 week ago