20 likes | 31 Views
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>
E N D