1 / 2

QNT 275 Week 5 Learning Team Assignment Apply: Week 5 Small Group Activity Case//tutorfortune.com

QNT 275 Week 5 Learning Team Assignment Apply: Week 5 Small Group Activity Case//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/qnt-275-week-5-learning-team-assignment-apply-week-5-small-group-activity-case<br><br>Instructions: You are the manager of a retail store and want to investigate how various metrics can improve the way you manage your business. Use the Week 5 Data Set to create and calculate the following in Microsoftu00ae Excelu00ae: <br>1.tConduct a goodness of fit analysis which assesses orders of a specific item by size and items you received by size.<br>2.tConduct 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. <br>u2022tIdentify the null and alternative hypotheses.<br>2.tGenerate 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.<br>u2022tSet up a hypothesis test to evaluate the strength of the relationship between the two variables.<br>3.tUse the regression line formula to forecast how much a customer might spend on merchandise if they visited the store 13 times in a 6month period.<br>4.tUse the average monthly sales of 2014 ($1,310) as your basis to:<br>u2022tCalculate indices for each month for the next two years.<br>u2022tGraph a time series plot. 5. In the Data Analysis Toolpak, use Excel's Exponential Smoothing option in order to: <br>u2022tApply a damping factor of 0.5 to your monthly sales data.<br>u2022tCreate a new time series graph that compares the original and revised monthly sales data. Click the Assignment Files tab to submit.<br><br>Click on below link to buy<br>https://tutorfortune.com/products/qnt-275-week-5-learning-team-assignment-apply-week-5-small-group-activity-case<br>

cukcuk12
Télécharger la présentation

QNT 275 Week 5 Learning Team Assignment Apply: Week 5 Small Group Activity Case//tutorfortune.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


More Related