Question: Please help me identify the patterns in the data and forecast for week 7 and show the forecast doe Thursday, Friday, Saturday, and Sunday of

Please help me identify the patterns in the data and forecast for week 7 and show the forecast doe Thursday, Friday, Saturday, and Sunday of week 7. I am not familiar with excel and am not sure what to put in the cells to get the right answer. I am using excel on a mac abd I would greatly appreciate an explination on how to input the answers as well. Thank you! :)

Query) D3 D E A B C 1 Please identify the patterns in the data and forecast for week 7 Meals Linear forecast Error Served Day 2 Week 130 3 1 Thurday 149 Friday 250 Saturday 166 Sunday 2 Thurday 134 Friday 154 9 Saturday 255 10 Sunday 162 11 3 Thurday 140 12 Friday 152 13 Saturday 260 14 Sunday 171 15 4 Thurday 145 16 Friday 150 17 Saturday 268 18 Sunday 173 19 5 Thurday 150 20 159 21 Friday Saturday Sunday 273 22 176 23 6 Thurday 156 24 Friday 163 25 Saturday 276 26 Sunday 183 27 7 Thurday 28 Friday 29 Saturday 30 Sunday 31 32 33 please forecast for Thurday, Friday, Saturday and Sundy of week 7 Q13 014 4 5 6 7 8 G Squared Abs Error Error H

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please help me identify the patterns in the data and forecasting for week 7 and forecast for Thursday, Friday, Saturday, and Sunday for week 7. I am on a mac using excel and am not too familiar with...

Janice Bray owns the Little Sister's Bakeshop and Coffee house. She would like to make a daily forecast of her July 1 through July 7 sales based on her 4-week rolling average prior daily sales. To be...

Week 1 Week 2 Week 3 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday t 0 1 2...

a) b) c) Number of customers Day Week 1 Week 2 Tuesday 50 46 39 32 Wednesday Thursday 40 30 Friday 87 93 Saturday 101 91 Sunday 60 80 Day Forecast Tuesday Wednesday Thursday Friday Saturday Sunday...

The questions that follow pertain to the economic study and valuation report for the Sample Inn. To answer the questions, open the report and the three Excel programs for the Sample Inn (in photos)....

Chapter 9, Problem 1 Please provide step by step directions in excel format as pictured below SOLVE BPH'S PROBLEMS 1. The lab supervisor needs to establish a weekly schedule for the morning shift....

Instruction Please note that you need to show all the steps of your calculations to receive full credit. Submit your report through Canvas. You can write or type a report, but the report must be...

1)Fill out the table, please round to three decimal places2)Find test statistic homework HW 2.1 Part 2 of 5 Points: 2 18 of 8 Save A researcher wanted to determine whether certain accidents were...

STATISTICAL ANALYSIS AND MODELLING FOR BUSINESS (BUS6090 - Section 2) Midterm - Show your work! NAME _________________ Use the Excel data file named Midterm Bus6090 data.xlsx to answer questions 1 -...

As a manager of a retail business, you need to prepare a work schedule for 8 employees. You have a co-manager (you can name them anything you want) I am your district manager and you must meet all...

If you see a house valued at $300,000 in Denver, find the price of a comparable house in Miami and Cheyenne. City Index City Index Denver Miami Phoenix Atlanta Baltimore 100 194 86 90 150 Boston Las...

Locate the centroid (x, y) of thearea. =1-2 2 m-

a) Calculate the inflation rate if the consumer price index changes from 123.0 to 129.15. b) Calculate the price index if there is 3.0 per cent inflation during the year and if the index was...

What is an example of constructive feedback? provide reference