Analytics Department for a Consulting Company, statistics homework help

User Generated

nfsy24

Mathematics

Description

Assignment Steps

Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics

Scenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze

  • Consumer Food

Provide a 1,600-word detailed, statistical report including the following:

  • Explain the context of the case
  • Provide a research foundation for the topic
  • Present graphs
  • Explain outliers
  • Prepare calculations
  • Conduct hypotheses tests
  • Discuss inferences you have made from the results

This assignment is broken down into four parts:

  • Part 1 - Preliminary Analysis
  • Part 2 - Examination of Descriptive Statistics
  • Part 3 - Examination of Inferential Statistics
  • Part 4 - Conclusion/Recommendations

Part 1 - Preliminary Analysis (3-4 paragraphs)

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective:

  • What are the questions you are trying to address?

Describe the population in the study clearly and in sufficient detail:

  • What is the sample?

Discuss the types of data and variables:

  • Are the data quantitative or qualitative?
  • What are levels of measurement for the data?

Part 2 - Descriptive Statistics (3-4 paragraphs)

Examine the given data.

Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary).

Identify any outliers in the data.

Present any graphs or charts you think are appropriate for the data.

Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics (2-3 paragraphs)

Use the Part 3: Inferential Statistics document.

  • Create (formulate) hypotheses
  • Run formal hypothesis tests
  • Make decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations (1-2 paragraphs)

Include the following:

  • What are your conclusions?
  • What do you infer from the statistical analysis?
  • State the interpretations in non-technical terms. What information might lead to a different conclusion?
  • Are there any variables missing?
  • What additional information would be valuable to help draw a more certain conclusion?

Format your assignment consistent with APA format.

Unformatted Attachment Preview

Week 6 Options QNT/561 Version 9 University of Phoenix Material Option: Consumer Food The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms. Copyright © 2017 by University of Phoenix. All rights reserved. 1 Part 3 Inferential Statistics QNT/561 Version 9 Part 3: Inferential Statistics Consumer Food 1. Suppose you want to test to determine if the average annual food spending for a household in the Midwest region of the U.S. is more than $8,000. Use the Midwest region data and a 1% level of significance to test this hypothesis. Assume that annual food spending is normally distributed in the population. 2. Test to determine if there is a significant difference between households in a metro area and households outside metro areas in annual food spending. Let α = 0.01. 3. The Consumer Food database contains data on Annual Food Spending, Annual Household Income, and Non-Mortgage Household Debt broken down by Region and Location. Using Region as an independent variable with four classification levels (four regions of the U.S.), perform three different one-way ANOVA's—one for each of the three dependent variables (Annual Food Spending, Annual Household Income, Non-Mortgage Household Debt). Did you find any significant differences by region? Copyright © 2017 by University of Phoenix. All rights reserved. 1 Region: 1 Location: Annual Annual Non = NE 2 = 1 = Metro Food Househol mortgage MW 3 = 2= Spending d Income household S 4 = Outside ($) ($) debt ($) W Metro 8909 56697 23180 1 1 5684 35945 7052 1 1 10706 52687 16149 1 1 14112 74041 21839 1 1 13855 63182 18866 1 1 15619 79064 21899 1 1 2694 25981 8774 1 1 9127 57424 15766 1 1 13514 72045 27685 1 1 6314 38046 8545 1 1 7622 52408 28057 1 1 4322 41405 6998 1 1 3805 29684 4806 1 1 6674 49246 13592 1 1 7347 41491 4088 1 1 2911 26703 15876 1 1 8026 48753 16714 1 1 8567 55555 16783 1 1 10345 71483 21407 1 1 8694 50980 19114 1 1 8821 46403 7817 1 1 8678 51927 14415 1 1 14331 84769 17295 1 1 9619 59062 16687 1 1 9286 57952 14161 1 1 8206 58355 19538 1 1 16408 81694 15187 1 1 12757 69522 14651 1 1 17740 96132 0 1 1 7739 57796 22057 1 1 15383 88276 1896 1 1 4579 32264 7979 1 1 11679 65928 0 1 1 12877 69924 27330 1 1 16232 91108 9876 1 1 9621 54070 19908 1 1 8171 47238 17819 1 1 12128 77427 31340 1 1 8642 59805 4963 1 1 12400 60334 6632 1 1 9185 54114 18593 1 2 7862 9775 6771 3059 13211 7408 11581 14233 3352 2630 9093 12652 9559 6112 10431 12630 4578 9551 10262 9551 10143 8955 10197 11234 9320 9089 12300 11484 11215 7204 5579 11723 9353 7761 4261 9830 12386 8673 10944 9910 9928 4264 7971 8290 12669 7272 9784 40680 58263 52008 39643 70309 46450 76140 80833 31899 21647 65924 65923 62811 42335 65134 64621 36553 62910 70727 57634 56549 59662 57350 56447 61136 51526 79979 66733 75359 40795 39128 75482 63998 45845 38223 66787 77852 55825 57022 64263 75881 34343 41243 53021 66991 49719 58399 15202 1486 21713 12179 13221 5602 33874 11478 2762 2663 11355 5132 12613 3149 15196 21433 5502 11376 13287 11857 16136 11627 18432 10871 0 4902 17270 15145 15611 8975 6576 12508 0 6671 8576 1178 936 14167 9018 12768 17423 21323 21009 20151 9250 20838 16065 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 9187 5866 9456 6270 9518 10968 8865 9226 4913 6976 8152 2887 8062 8895 8444 6148 4563 8185 3391 7436 9522 11290 10403 4693 5626 11869 13055 8783 13031 3681 5549 4108 6314 7700 7479 9093 9863 8043 9552 9286 7987 3875 10746 6888 5479 6949 10650 50477 39112 51886 34797 62348 78704 53620 51577 34761 60968 51281 25013 59238 47344 52645 35309 34355 50630 29056 48721 50459 72805 56954 39343 38833 55021 77605 57937 63343 36479 40381 26309 41421 54579 40551 50369 54422 51836 73600 51873 48003 36519 75152 44974 48923 43769 75947 9407 20409 11668 146 5201 17002 32004 15922 17704 17799 8167 18763 10815 11814 22469 17139 10612 21187 15735 18363 16478 21238 22218 24696 14371 35576 817 18591 25531 17950 14257 26581 22470 29065 31757 6404 24334 26213 36374 29631 17261 13579 10659 23711 4594 21221 33357 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 5188 5311 4691 8056 11304 8112 8696 5869 3776 11829 13087 10986 5762 11617 9895 16293 8185 13972 11243 4635 10063 8426 7436 11747 15397 6842 9678 12852 10114 8496 6689 15696 9841 12529 10210 8868 6426 11096 10086 2587 12492 8456 6801 6339 7802 9717 6026 41423 40189 36772 59690 53654 59067 65962 37254 33568 56934 88822 59635 38407 78627 47710 64443 58871 87954 54778 39825 49536 60102 49139 51052 70500 54894 60570 57625 56956 61400 50532 72774 69981 66891 67431 64782 38987 64867 50421 27076 51784 54135 53291 49804 52205 72841 46238 33641 17791 5829 19594 23066 240 0 10157 14143 0 17565 27863 18867 11894 22930 31687 35424 11549 12552 19494 12195 13787 22356 4553 12025 16217 4106 31228 25907 1093 17106 17793 21607 17689 19995 14489 17864 5839 8689 17534 20284 22037 23342 34943 28579 22349 20165 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 5618 10217 8338 9048 4017 10906 15148 8830 8481 11358 10553 6969 13219 3543 7326 8458 11766 9908 45938 77716 59711 42106 36462 53403 71290 66759 57616 76221 78202 55164 61171 34093 50647 59898 52884 73629 10538 18516 7980 19786 9935 18177 6696 20972 28767 1373 5920 24795 21482 25969 10750 22940 25970 7112 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags