Use the Week 5 Data Set to create and calculate the following in Excel®

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®:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
You can leave a response, or trackback from your own site.


10 Responses to “Use the Week 5 Data Set to create and calculate the following in Excel®”

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

  2. 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

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

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

  5. 안전공원 says:

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

  6. Azure DevOps says:

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

  7. cheap wigs says:

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

  8. 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

  9. 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

  10. 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

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes