Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the entire question. I need have this done by this evenning. Please and Thank you. The link below provides the data on two

This is the entire question. I need have this done by this evenning. Please and Thank you. The link below provides the data on two different spread sheets. It has to be done on excel. http://faculty.uml.edu/mstick/92.122/material/Walmart dry goods weekly sales.htm Project 1: The data used is from the Methuen Walmart store infiscal 2002 - 2003 and fiscal 2003 - 2004. Walmart's fiscal year starts with the first week of February, so week 1 in 2002 is the first week in February and week 52 (or week 53 based on roundoff) occurs during the last week of January in 2003. Questions: 1. Can you identify holiday periods or special events that cause the spikes in the data? 2. What holiday results in the maximum sales for this department? 3. Generate several linear models for this data and discuss the rational behind the model that you believe best predicts future results. a. For each linear model, discuss the meaning of the slope and y intercept. b. Using your most preferred linear model, predict sales for the next four weeks. Provide backup computation. 4. Based on your favorite linear model selected, compute the percent rate of increase (y2 - y1)/ y1 for the next four weeks. http://faculty.uml.edu/mstick/92.122/material/Walmart dry goods weekly sales.htm

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

Multinational Finance

Authors: Kirt Butler

2nd Edition

0324004508, 978-0324004502

More Books

Students also viewed these Finance questions