You are the manager of a retail store. You want to investigate how metrics can improve the way you manage your business.

**Use** the Week 5 Data Set to **create** and **calculate** the following in Excel^{®}:

- Conduct a goodness of fit analysis which assesses orders of a specific item by size and items you received by size.
- Conduct a hypothesis test with the objective of determining if there is a difference between what you ordered and what you received at the .05 level of significance.
- Identify the null and alternative hypotheses.

- Generate a scatter plot, the correlation coefficient, and the linear equation that evaluates whether a relationship exists between the number of times a customer visited the store in the past 6 months and the total amount of money the customer spent.
- Set up a hypothesis test to evaluate the strength of the relationship between the two variables.
- Use a level of significance of .05.

- Use the regression line formula to forecast how much a customer might spend on merchandise if that customer visited the store 13 times in a 6 month period. Consider the average monthly sales of 2014, $1310, as your base to:
- Calculate indices for each month for the next two years.
- Graph a time series plot.

- In the Data Analysis Toolpak, use Excel’s Exponential Smoothing option.
- Apply a damping factor of .5, to your monthly sales data.
- Create a new time series graph that compares the original and the revised monthly sales data.

494450 199952Quite fascinating information !Perfect just what I was looking for! 17455

577148 212844You could surely see your skills in the function you write. The world hopes for far more passionate writers like you who arent afraid to say how they believe. At all times follow your heart 937486

324583 841660This internet internet site is my aspiration, extremely outstanding style and style and Perfect subject matter. 256523

791732 803035Id always want to be update on new weblog posts on this internet site , bookmarked ! . 679138

766936 570312I adore your wp internet template, wherever would you obtain it via? 296666

721705 85646Quite fascinating subject , appreciate it for posting . 499103

68896 515611Hi, have you ever before asked yourself to write about Nintendo or PSP? 457388

436690 258299I needs to spend some time learning much more or figuring out more. Thank you for wonderful information I used to be searching for this information for my mission. 449334

516547 360829You may be websites successful individuals, it comes effortlessly, therefore you also earn you see, the jealousy of all the ones a lot of journeymen surrounding you could have challenges within this challenge. motor movers 247427

883407 484176Keep up the wonderful piece of work, I read couple of posts on this internet website and I believe that your internet weblog is really interesting and contains lots of superb details. 710563