Statistics Concepts and Descriptive Measures, statistics homework help

User Generated

Oyvmmneq64

Mathematics

Description

Purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start.

Assignment Steps

This assignment has an Excel® dataset spreadsheet attached. You will be required to only do one of the three datasets.

Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data Set

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment:

  • Consumer Food ( This is the one I chose)
  • Financial
  • Hospital

Answer each of the following in a total of 90 words:

  • For each column, identify whether the data is qualitative or quantitative.
  • Identify the level of measurement for the data in each column.
  • For each column containing quantitative data:
    • Evaluate the mean and median
    • Interpret the mean and median in plain non-technical terms
    • Use the Excel =AVERAGE function to find the mean
    • Use the Excel =MEDIAN function to find the median
  • For each column containing quantitative data:
    • Evaluate the standard deviation and range
    • Interpret the standard deviation and range in plain non-technical terms
    • Use the Excel =STDEV.S function to find the standard deviation
    • For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function

Unformatted Attachment Preview

Statistics Concepts and Descriptive Measures Grading Guide QNT/561 Version 9 Applied Business Research and Statistics Copyright Copyright © 2017, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008 by University of Phoenix. All rights reserved. University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries. Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation. Statistics Concepts and Descriptive Measures Grading Guide Edited in accordance with University of Phoenix® editorial standards and practices. 2 Statistics Concepts and Descriptive Measures Grading Guide Individual Assignment: Statistics Concepts and Descriptive Measures Purpose of Assignment The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel prior to the course start. Resources Required • • Microsoft Excel® Statistics Concepts and Descriptive Measures Data Set Grading Guide Content This assignment has an Excel® dataset spreadsheet attached. Students will be required to do one of the three datasets only and submit. Download the Consumer Food, Financial, or Hospital Excel® Data Set. Note: you have to work on only ONE dataset and not ALL. Answer each of the following in a total 90 words: • For each column, identify whether the data is qualitative or quantitative. • Identify the level of measurement for the data in each column. • For each column containing quantitative data: o o o o • Evaluate the mean and median Interpret the mean and median in plain non-technical terms Use the Excel =AVERAGE function to find the mean Use the Excel =MEDIAN function to find the median For each column containing quantitative Met Partially Met Not Met Comments: 3 Statistics Concepts and Descriptive Measures Grading Guide Content Met Partially Met Not Met Total Available Total Earned 3 #/3 Partially Met Not Met Total Available Total Earned 2 #/2 5 #/5 Comments: data: o o o Evaluate the standard deviation and range Interpret the standard deviation and range in plain non-technical terms Use the Excel =STDEV.S function to find the standard deviation For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function Writing Guidelines Met The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. Intellectual property is recognized with in-text citations and a reference page. Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper. Sentences are complete, clear, and concise. Rules of grammar and usage are followed including spelling and punctuation. Assignment Total Additional comments: # Comments: 4 Statistics Concepts and Descriptive Measures Grading Guide 5 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 Company Type AFLAC Albertson's Allstate Amerada Hess American General American Stores Amoco Arco Chemical Ashland Atlantic Richfield Bausch & Lomb Baxter International Bristol-Myers Squibb Burlington Coat Central Maine Power Chevron CIGNA Cinergy Dayton Hudson Dillard's Dominion Resources Dow Chemical DPL E. I. DuPont DeNemours Eastman Chemical Edison International Engelhard Entergy Equitable Ethyl Exxon FPL Group The GAP Georgia Gulf GIANT Food A&P Great Lakes Chemicals Green Mountain Power Company Hannaford Bros. Hercules Houston Industries Jefferson-Pilot Johnson & Johnson Liberty The Limited Lincoln National 6 4 6 7 6 4 7 2 7 7 5 5 5 1 3 7 6 3 1 1 3 2 3 2 2 3 2 3 6 7 7 3 1 2 4 4 2 3 4 2 3 6 5 6 1 6 Total Revenues Total Assets Return on Equity 7251 29454 17,1 14690 5219 21,4 20106 80918 20,1 8340 7935 0,2 3362 80620 7,1 19139 8536 12,2 36287 32489 16,7 3995 4116 6,2 14319 7777 9,5 19272 25322 21,8 1916 2773 6 6138 8707 11,5 16701 14977 44,4 1777 775 12,3 954 2299 2,4 41950 35473 18,6 14935 108199 13,7 4353 8858 13,3 27757 14191 18 6817 5592 9,2 7678 20193 7,9 20018 24040 23,6 1356 3585 13,9 46653 42942 21,3 4678 5778 16,3 9235 25101 12,3 3631 2586 6,1 9562 27001 4,2 9666 151438 12,3 1064 1067 53,6 137242 96064 19,4 6369 12449 12,2 6508 3338 33,7 966 613 228 4231 1522 7,9 10262 2995 6,9 1311 2270 5,5 179 326 8,3 3226 1227 9,9 1866 2411 47 6873 18415 8 2578 23131 14,5 22629 21453 26,7 660 3185 11,1 9189 4301 10,6 4899 77175 0,4 Lubrizol Lyondell Petrochemical Mallinkrodt May Department Stores McKesson Mercantile Stores Merck Millennium Chemicals Mobil Monsanto Morton Murphy Oil Mylan Laboratories NALCO Chemical Nevada Power NIPSCO Olin Orion Capital Owens & Minor Pacific Corporation J. C. Penney Pennzoil Pfizer Pharmacia & Upjohn Phillips Petroleum Poe & Brown PPG PP&L Resources Progressive Rohm & Haas Ruddick Schering-Plough Sears, Roebuck Stryker Sun Sunamerica Texaco The TJX Companies Torchmark Tosco Travelers Ultramar Diamond Shamrock Union Carbide United States Surgical Corporation UNOCAL UNUM USX-Marathon 2 7 5 1 5 1 5 2 7 2 2 7 5 2 3 3 2 6 5 3 1 7 5 5 7 6 2 3 6 2 4 5 1 5 7 6 7 1 6 7 6 7 2 5 7 6 7 1674 3010 1868 12685 20857 3144 23637 3048 65906 7514 2388 2138 555 1434 799 2587 2410 1591 3117 6278 30546 2654 12504 6710 15424 129 7379 3049 4190 3999 2300 6778 41296 980 10531 2114 46667 7389 2283 13282 37609 10882 6502 1172 6064 4077 15754 1462 1559 2988 9930 5608 2178 25812 4326 43559 10774 2805 2238 848 1441 2339 4937 1946 3884 713 13880 23493 4406 15336 10380 13860 194 6868 9485 7560 3900 885 6507 38700 985 4667 35637 29600 2610 10967 5975 386555 5595 6964 1726 7530 13200 10565 19 46,2 14,8 20,5 11 7,9 36,6 12,6 16,8 7,2 12,3 12,3 13,5 25 10,1 14,1 17,4 16 9,4 5,2 7,7 15,8 27,9 5,8 19,9 25,1 28,5 11,4 18,7 19,8 12,5 51,2 20,3 20,5 18 14,7 20,9 26,3 17,5 10,9 14,9 9,5 28,8 7,5 28,9 15,2 12,6 Valero Energy Warner-Lambert WEIS Markets Wellman Winn-Dixie Stores WITCO Zenith Nation Insurance 7 5 4 2 4 2 6 5756 8180 1819 1083 13219 2187 601 2493 8031 972 1319 2921 2298 1252 9,6 30,7 9,2 4,8 15,3 14 7,8 Earnings per Share Average Yield 2,08 2,08 3,56 0,08 2,19 1,01 2,76 1,14 3,8 5,41 0,89 1,06 3,14 1,18 0,16 4,95 4,88 1,59 1,7 2,31 2,15 7,7 1,2 2,08 3,63 1,73 0,33 1,03 2,86 0,71 3,37 3,57 1,3 2,39 1,18 1,66 1,19 1,57 1,4 3,18 1,66 3,47 2,41 3,34 0,79 0,21 Dividends per Share 0,9 1,6 1 1,1 3 1,4 3,1 6,1 2,3 3,8 2,6 2,3 2 0,1 7,8 3 2 5,1 1,2 0,4 6,8 3,6 5,3 2,1 3 4,2 1,9 6,9 0,5 5,6 2,8 3,7 0,7 1,1 2,4 1,2 1,3 7,3 1,5 2,2 6,6 2,3 1,5 1,8 2,3 3,1 Average P/E Ratio 0,22 0,63 0,36 0,6 1,4 0,34 1,4 2,8 1,1 2,83 1,04 1,13 1,52 0,02 0,9 2,28 1,1 1,8 0,33 0,16 2,58 3,24 0,91 1,23 1,76 1 0,38 1,8 0,2 0,5 1,63 1,92 0,2 0,32 0,78 0,35 0,62 1,61 0,54 1 1,5 1,04 0,85 0,77 0,48 1,96 11,5 19 10,6 698,3 21,2 23,5 16,1 40,4 12,4 3,8 2,6 47,2 24,1 12,9 79,6 15,2 11,4 22,4 16,2 15,7 17,7 11,6 14,3 27,9 16 13,6 61,8 25,4 13,4 12,6 17,1 14,4 22 11,8 26,9 17,8 40,5 14 26,6 14,5 13,7 13,3 24,1 12,7 26,7 300,2 2,66 3,58 2,47 3,11 1,59 3,53 3,74 2,47 4,01 0,48 1,48 2,94 0,82 2,1 1,65 1,53 3 4,15 0,6 0,68 2,1 3,76 1,7 0,61 3,61 1,48 3,94 1,8 5,31 2,13 1,02 1,95 2,99 1,28 2,7 1,8 4,87 1,75 2,39 1,37 2,54 1,94 4,53 1,21 2,65 2,59 1,58 2,6 3,9 1,7 2,4 1,2 2,1 1,7 2,9 3,1 1,1 1 2,6 0,9 2,6 6,8 4,1 2,8 1,5 1,4 4,6 3,8 1,6 1,1 3,1 3 1,5 2,3 7,7 0,3 2,2 1,8 1,5 1,8 0,3 2,8 0,9 3,1 0,6 1,7 0,8 0,9 3,5 1,6 0,5 2 1,3 2,4 1,01 0,9 0,66 1,2 0,5 1,19 1,69 0,6 2,12 0,5 0,36 1,35 0,16 1 1,6 0,9 1,2 0,6 0,18 1,08 2,13 1 0,68 1,08 1,34 0,35 1,33 1,67 0,24 0,63 0,32 0,74 0,92 0,11 1 0,3 1,75 0,09 0,59 0,24 0,4 1,1 0,79 0,16 0,8 0,56 0,76 14,5 6,4 16 16,2 26 16,3 26,6 8,3 17,2 90,7 25,2 18 22,4 18,3 14,2 14,4 14,5 9,8 21,7 34,2 26,9 17,1 35,4 56,2 12,4 16,3 14,7 12 17 13,4 17 24,6 17,4 27,2 13 19,5 11,5 8,2 14,2 23 17 16,1 10,7 29 15,5 17 19,8 2,03 1,04 1,87 0,97 1,36 1,55 1,57 1,2 1,4 3 1,8 2,7 2,9 3,7 0,42 0,51 0,94 0,35 0,98 1,12 1 17,2 35,7 16,9 20,5 27,2 24,9 17 Hospital 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Geog. Region Control 1 1 1 1 7 4 4 4 1 1 1 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 5 5 5 2 2 2 1 1 1 1 1 1 1 1 1 1 Service 2 1 2 1 1 2 4 2 2 1 1 3 3 2 4 1 3 2 3 3 3 2 2 1 3 2 2 3 3 2 2 2 2 2 2 2 3 2 1 2 3 1 2 2 1 3 Beds 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 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 210 347 511 142 40 220 137 80 440 48 56 46 109 306 7 16 167 444 236 247 93 236 220 228 83 273 225 236 80 78 197 60 31 264 246 556 56 120 674 414 320 315 344 168 315 88 AdmissionsCensus Outpat. Visits Births 7713 107 86982 312 16065 198 149222 1077 23028 356 222565 1027 4338 100 36710 355 905 9 13350 168 15563 159 88721 3810 5347 65 188885 735 636 48 10209 1 15954 253 77343 1733 1827 21 33977 257 1617 27 17925 169 2954 30 27170 430 2805 43 30263 0 9871 233 43128 2049 756 2 96000 211 342 11 7217 16 8426 84 66073 2648 18258 219 170223 2450 8280 112 31022 1465 5449 124 44425 0 5247 50 29551 1993 11301 142 90178 2275 9466 111 172146 1494 10444 140 95649 1313 2648 28 15507 451 9249 154 51102 1689 7763 150 91654 1583 10688 144 68482 2017 6671 42 35221 995 7761 77 37370 2045 9553 119 153994 1686 2730 27 16060 503 1112 15 36735 126 13395 179 267091 2026 12264 175 140152 1412 12811 461 68330 1517 860 32 5778 0 5502 74 36461 0 26547 414 294682 2719 12260 253 81885 1074 4147 180 47636 1421 12804 184 92458 762 16539 243 185313 3194 7566 115 66309 496 15853 215 93373 1442 2662 48 6533 0 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 1 1 1 1 1 1 1 1 7 7 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 1 1 1 1 1 1 2 3 2 1 1 3 2 1 2 2 3 1 3 2 2 2 2 2 3 2 2 2 4 2 2 1 3 1 2 2 2 1 2 2 1 3 1 1 3 4 1 2 3 3 2 1 3 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 2 1 1 1 1 2 1 1 1 1 245 311 233 46 103 331 186 177 149 286 488 242 128 33 255 481 191 60 155 626 105 59 258 47 22 53 244 352 366 194 109 285 175 342 140 50 214 80 467 80 160 106 40 99 133 138 88 8733 15196 1466 812 2312 2305 10541 4469 5994 11142 508 5682 5511 925 13780 28390 9899 1247 9893 31452 1456 4706 9950 1940 1241 1475 9731 14974 7284 5356 458 11624 8080 1259 2876 404 794 746 6122 823 6584 3870 859 3313 6306 2764 4112 124 189 181 9 28 288 108 154 76 165 295 101 69 12 185 378 114 49 106 460 43 29 125 17 10 14 173 207 223 82 64 139 109 298 52 34 168 21 390 47 80 50 113 45 76 129 60 78773 115155 18659 11519 30661 35600 76176 57104 111901 173393 0 37461 37898 24679 146454 796525 85986 35955 192386 236900 47152 292105 121004 45057 31833 43357 103595 110754 181430 48413 26770 599315 200048 0 3192 13468 0 10074 179676 10409 91769 53424 2251 30814 172253 17907 85800 1107 2989 113 0 0 173 1064 759 1317 1751 0 0 714 99 2243 3966 1308 0 2514 3714 126 556 1327 415 216 339 1217 2641 790 520 35 1168 793 0 0 14 0 0 0 0 776 451 0 145 1284 1 319 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 1 1 1 3 3 3 3 3 5 5 5 5 3 3 3 5 5 5 2 2 2 2 2 2 5 5 5 2 2 2 2 2 2 1 2 4 2 1 3 3 4 1 3 2 1 2 2 3 1 1 1 4 3 1 4 2 1 4 2 3 1 2 3 3 1 4 3 3 2 2 1 1 2 2 2 1 1 1 1 1 1 1 2 2 1 1 2 1 2 2 1 1 1 1 1 2 1 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 573 44 225 105 100 186 375 485 64 495 114 62 149 427 40 129 149 71 256 153 1297 70 69 71 243 206 62 219 54 24 151 160 262 296 671 184 249 157 100 100 375 123 457 263 160 69 153 26392 1497 8187 6251 5335 8184 21169 4112 1785 21327 538 883 1897 592 1049 9507 1589 617 7203 6156 1407 1609 1666 3477 5667 1499 1256 9275 143 1503 1764 3228 3689 14018 37375 7699 7931 2018 510 2271 11821 4093 16987 19776 7798 2814 3611 418 17 138 64 62 131 265 456 40 310 72 19 112 375 15 78 123 54 96 82 1106 30 56 36 127 180 59 127 37 13 100 47 194 172 516 120 179 140 78 68 186 91 340 254 108 61 174 121321 35357 89248 103225 172105 87453 331478 109270 7749 312733 0 5850 69776 0 0 64109 13721 48469 107440 4170 5551 14630 6376 238060 161912 0 68886 42058 3224 105101 27889 29179 57144 139741 119462 53313 88869 102547 935 13405 184144 36172 304839 362424 87511 64651 69833 2154 295 496 589 806 701 3968 0 0 3655 0 0 0 0 0 3063 169 66 827 570 0 0 0 342 494 0 0 0 0 286 235 339 398 1275 5699 1364 714 0 0 0 779 0 2202 3346 1071 352 254 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 2 2 2 2 2 1 1 1 1 1 3 3 3 3 3 3 3 3 3 3 7 7 7 7 7 2 2 2 2 2 1 1 1 3 3 1 1 1 1 1 1 1 1 1 5 5 5 1 3 2 2 1 2 1 4 1 2 2 2 4 1 2 2 1 3 4 1 2 1 1 4 2 1 4 2 2 2 4 3 3 4 2 2 3 3 2 3 4 3 3 3 3 1 2 2 2 1 1 1 1 1 2 1 1 1 1 2 2 1 1 2 1 1 2 1 1 1 1 1 2 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 260 34 479 973 440 51 347 612 141 115 50 261 334 228 85 357 189 139 60 164 105 114 73 314 350 602 74 53 152 317 43 269 79 181 122 65 97 169 407 160 117 80 100 370 123 380 149 163 213 4848 24753 21004 111 19026 3378 4080 2030 944 10112 4410 515 3233 14900 1076 4014 3108 1132 7528 6685 568 8408 17484 570 1426 1963 5373 14275 1438 11508 4044 3217 2938 3246 2481 5348 16466 6504 12209 1266 767 8974 4085 16647 8479 306 28 395 923 335 46 316 416 74 86 38 147 232 138 38 245 171 51 28 797 56 69 40 163 231 523 31 43 66 231 11 144 43 185 82 49 24 63 274 93 86 28 25 181 39 302 80 56662 0 262583 339009 550588 1257 287498 129088 54460 32678 14995 86607 109111 0 67906 279079 0 59061 202739 42432 98805 27365 11443 289471 196534 0 85674 848 65824 162753 287501 172047 83963 169698 65898 51167 62150 64834 134581 30246 813369 3813 5742 53406 56073 31412 209595 0 0 699 2462 3311 0 4207 0 339 130 91 1143 0 0 509 1026 0 447 1161 0 922 562 78 0 2122 0 0 0 710 1165 466 1106 376 0 637 0 352 447 1227 963 3038 0 0 868 1189 2849 1728 188 189 190 191 192 193 194 195 196 197 198 199 200 5 2 2 1 1 1 7 7 7 7 5 5 5 2 2 2 1 2 3 2 1 2 2 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 112 61 219 260 350 121 206 70 334 190 122 170 73 7260 2730 2161 13943 12132 7894 4567 2089 15696 6395 441 7244 352 63 31 170 203 296 83 84 29 187 77 104 85 47 163261 59584 14923 138404 100323 85585 107027 24369 102641 244254 0 167454 9714 2171 364 0 2993 0 1964 601 387 1946 545 0 838 51 Tot. Exp. Payroll Exp.Personnel 56831 22061 792 127223 55799 1762 157093 61326 2310 24462 10503 328 13730 6368 181 93257 33920 1077 45458 26919 742 6151 2768 131 98992 40956 1594 11569 5664 233 11356 5084 241 15200 7085 203 20848 9709 325 62778 28958 676 20300 12300 347 3836 2015 79 41417 20633 505 144966 61667 1543 67997 31285 755 123175 41899 959 28318 12589 325 88080 32191 954 107313 38668 1091 116486 49017 671 20625 3009 300 67519 28066 753 60080 21944 607 94401 38757 929 26094 13464 354 38825 15951 408 105672 46710 1251 29444 12583 386 8496 3918 144 153844 86780 2047 128312 63615 1343 122809 63516 1723 7079 3202 96 50823 20346 529 367706 165344 3694 85696 34117 1042 29699 12391 1071 108848 43575 1525 141031 56421 1983 56207 22128 670 131297 52366 1653 9617 4735 167 63442 109394 9840 4417 31628 20848 56185 43406 40014 75810 26298 57236 30063 7947 143118 270244 83223 20151 105523 323725 15701 33014 88222 22274 10900 14830 71691 155097 55926 42104 6428 127796 65083 28246 22324 2547 21517 4861 114160 8086 45492 24529 4663 16296 55663 32936 29164 28088 47744 5593 2455 10847 10389 24373 21388 17450 32620 21070 21461 14717 3388 56630 113093 38537 8139 40048 143991 7478 6272 35949 11191 5542 6624 33804 61771 24520 17721 3280 56476 28006 18783 9346 1235 13795 2591 69051 3623 18955 9420 2569 7925 22064 10177 13663 793 841 316 93 373 263 943 605 596 1165 568 507 479 136 1456 3486 885 243 1001 3301 337 1193 1161 322 185 205 1224 1704 815 712 156 1769 875 790 308 70 494 111 1618 244 525 472 94 297 847 234 401 329667 17714 84347 43323 53578 76537 188190 103822 8723 231187 16083 5283 34946 53604 4479 58597 14738 7934 88779 35543 73334 4937 14307 53307 43013 21260 29581 160226 3043 21939 17395 26343 36112 156543 239458 56221 45034 46804 2082 17874 102559 36922 322786 196619 68084 35452 24702 128158 7700 45164 17837 28592 33789 86172 58336 4871 100456 7789 2637 23156 34280 2171 22611 7040 4130 43895 13390 47273 3172 7260 22512 20808 14755 13762 72855 1637 9481 6604 11304 18621 58378 100322 18421 24427 22395 1533 7685 47925 15160 170956 81345 30310 18210 12706 3928 198 1231 545 663 820 2581 1298 126 2534 251 85 432 864 66 556 347 239 973 439 1849 102 262 885 549 611 330 1471 75 262 328 377 575 1916 2620 571 703 535 160 202 1330 370 3123 2745 815 576 502 50850 4861 55313 343160 275305 2435 180781 104009 31187 13706 6885 155709 80088 27911 26229 143322 27683 36847 27790 12990 48914 48855 6148 176241 173817 62703 41680 6584 38863 131696 43490 84731 39452 71806 26355 14183 15241 38483 148287 54167 118076 6026 6390 80866 31770 241842 56095 35000 2032 24742 188865 147417 1053 83474 55542 15242 5352 3841 78535 43948 17394 12487 72409 17784 10861 14969 7256 23004 24584 2917 86574 80414 38412 16082 4779 16583 70732 25993 28639 11190 39192 10272 7723 6424 11568 54588 21347 51986 3084 2695 30372 10260 98138 21266 808 50 728 4087 3012 68 3090 1358 576 284 145 2312 1124 336 415 1779 338 453 437 261 609 647 61 2074 2232 948 409 153 741 1625 538 789 395 956 362 144 229 396 2256 731 1477 102 106 939 392 3516 785 43977 23025 31366 97659 96458 46491 39836 17257 168045 79859 15321 58247 4565 21292 9410 18090 42580 45898 21744 20671 7425 78118 33639 8878 25018 2228 607 273 630 1379 1108 583 514 216 1593 1055 399 834 104
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is the answer. Thanks

Central location measures including mean, medina, mode etc., and dispersion measures
including variance, standard deviation, range etc. cane be used to understand the data properties
and take decision. This paper aims at reviewing the data type, level of measurement, central
location & dispersion measures of food data of 200 customers.
Descriptive Measures of Consumer Food Data
Data Type
The data represented the first three columns namely- annual food spending, annual
household income, and non-mortgage household debt are quantitative data in nature. Numerical
values based on which each customers can be analyzed and assessed quantitatively has been
assigned for each of these variables. The data represented in the fourth and fifth column namelyregion and location are qualitative data. The location and state of the consumers can be known
from these data. No quantitative analysis can be made with these data.
Level of Measurement
The data represented in the first three columns are ratio level data. Besides on these data
categorization and ordering of the customers can be made. Beside these, each of these data has
equal interval and zero values of these are meaningful. The data represented in the last two
columns namely customer region, and customer location are nominal level data. With these data,
customers can be categorized but cannot be ordered. Nominal level data contains data based on
which only categorization can be made only.
Measures of Location
The mean of the annual food spending, annual household income, and non-mortgage
household debt of the consumers are 8966.1, 55552.4, and 15604.2 respectively. These means

value represent the expected value or typical value (average) of annual food spending, annual
household income, and non-mortgage household debt of the consumers.
The median value of the annual food spending, annual household income, and nonmortgage household debt of the consumers are 8932.0, 54957.5, and 16100.2 respectively. These
median value represent medium values when the annual food spending, annual household
income, and non-mortgage household debt data of t...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags