Annual Food Spending ($) | Annual Household Income ($) | Non mortgage household debt ($) | Region: 1 = NE 2 = MW 3 = S 4 = W | Location: 1 = Metro 2 = Outside 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 | 40680 | 15202 | 1 | 2 |
9775 | 58263 | 1486 | 1 | 2 |
6771 | 52008 | 21713 | 1 | 2 |
3059 | 39643 | 12179 | 1 | 2 |
13211 | 70309 | 13221 | 1 | 2 |
7408 | 46450 | 5602 | 1 | 2 |
11581 | 76140 | 33874 | 1 | 2 |
14233 | 80833 | 11478 | 1 | 2 |
3352 | 31899 | 2762 | 1 | 2 |
2630 | 21647 | 2663 | 1 | 2 |
9093 | 65924 | 11355 | 1 | 2 |
12652 | 65923 | 5132 | 1 | 2 |
9559 | 62811 | 12613 | 1 | 2 |
6112 | 42335 | 3149 | 1 | 2 |
10431 | 65134 | 15196 | 1 | 2 |
12630 | 64621 | 21433 | 1 | 2 |
4578 | 36553 | 5502 | 1 | 2 |
9551 | 62910 | 11376 | 1 | 2 |
10262 | 70727 | 13287 | 1 | 2 |
9551 | 57634 | 11857 | 2 | 1 |
10143 | 56549 | 16136 | 2 | 1 |
8955 | 59662 | 11627 | 2 | 1 |
10197 | 57350 | 18432 | 2 | 1 |
11234 | 56447 | 10871 | 2 | 1 |
9320 | 61136 | 0 | 2 | 1 |
9089 | 51526 | 4902 | 2 | 1 |
12300 | 79979 | 17270 | 2 | 1 |
11484 | 66733 | 15145 | 2 | 1 |
11215 | 75359 | 15611 | 2 | 1 |
7204 | 40795 | 8975 | 2 | 1 |
5579 | 39128 | 6576 | 2 | 1 |
11723 | 75482 | 12508 | 2 | 1 |
9353 | 63998 | 0 | 2 | 1 |
7761 | 45845 | 6671 | 2 | 1 |
4261 | 38223 | 8576 | 2 | 1 |
9830 | 66787 | 1178 | 2 | 1 |
12386 | 77852 | 936 | 2 | 1 |
8673 | 55825 | 14167 | 2 | 1 |
10944 | 57022 | 9018 | 2 | 1 |
9910 | 64263 | 12768 | 2 | 1 |
9928 | 75881 | 17423 | 2 | 1 |
4264 | 34343 | 21323 | 2 | 1 |
7971 | 41243 | 21009 | 2 | 1 |
8290 | 53021 | 20151 | 2 | 1 |
12669 | 66991 | 9250 | 2 | 1 |
7272 | 49719 | 20838 | 2 | 1 |
9784 | 58399 | 16065 | 2 | 1 |
9187 | 50477 | 9407 | 2 | 1 |
5866 | 39112 | 20409 | 2 | 1 |
9456 | 51886 | 11668 | 2 | 2 |
6270 | 34797 | 146 | 2 | 2 |
9518 | 62348 | 5201 | 2 | 2 |
10968 | 78704 | 17002 | 2 | 2 |
8865 | 53620 | 32004 | 2 | 2 |
9226 | 51577 | 15922 | 2 | 2 |
4913 | 34761 | 17704 | 2 | 2 |
6976 | 60968 | 17799 | 2 | 2 |
8152 | 51281 | 8167 | 2 | 2 |
2887 | 25013 | 18763 | 2 | 2 |
8062 | 59238 | 10815 | 2 | 2 |
8895 | 47344 | 11814 | 2 | 2 |
8444 | 52645 | 22469 | 2 | 2 |
6148 | 35309 | 17139 | 2 | 2 |
4563 | 34355 | 10612 | 2 | 2 |
8185 | 50630 | 21187 | 3 | 1 |
3391 | 29056 | 15735 | 3 | 1 |
7436 | 48721 | 18363 | 3 | 1 |
9522 | 50459 | 16478 | 3 | 1 |
11290 | 72805 | 21238 | 3 | 1 |
10403 | 56954 | 22218 | 3 | 1 |
4693 | 39343 | 24696 | 3 | 1 |
5626 | 38833 | 14371 | 3 | 1 |
11869 | 55021 | 35576 | 3 | 1 |
13055 | 77605 | 817 | 3 | 1 |
8783 | 57937 | 18591 | 3 | 1 |
13031 | 63343 | 25531 | 3 | 1 |
3681 | 36479 | 17950 | 3 | 1 |
5549 | 40381 | 14257 | 3 | 1 |
4108 | 26309 | 26581 | 3 | 1 |
6314 | 41421 | 22470 | 3 | 1 |
7700 | 54579 | 29065 | 3 | 1 |
7479 | 40551 | 31757 | 3 | 1 |
9093 | 50369 | 6404 | 3 | 1 |
9863 | 54422 | 24334 | 3 | 1 |
8043 | 51836 | 26213 | 3 | 2 |
9552 | 73600 | 36374 | 3 | 2 |
9286 | 51873 | 29631 | 3 | 2 |
7987 | 48003 | 17261 | 3 | 2 |
3875 | 36519 | 13579 | 3 | 2 |
10746 | 75152 | 10659 | 3 | 2 |
6888 | 44974 | 23711 | 3 | 2 |
5479 | 48923 | 4594 | 3 | 2 |
6949 | 43769 | 21221 | 3 | 2 |
10650 | 75947 | 33357 | 3 | 2 |
5188 | 41423 | 33641 | 3 | 2 |
5311 | 40189 | 17791 | 3 | 2 |
4691 | 36772 | 5829 | 3 | 2 |
8056 | 59690 | 19594 | 3 | 2 |
11304 | 53654 | 23066 | 3 | 2 |
8112 | 59067 | 240 | 3 | 2 |
8696 | 65962 | 0 | 3 | 2 |
5869 | 37254 | 10157 | 3 | 2 |
3776 | 33568 | 14143 | 3 | 2 |
11829 | 56934 | 0 | 3 | 2 |
13087 | 88822 | 17565 | 4 | 1 |
10986 | 59635 | 27863 | 4 | 1 |
5762 | 38407 | 18867 | 4 | 1 |
11617 | 78627 | 11894 | 4 | 1 |
9895 | 47710 | 22930 | 4 | 1 |
16293 | 64443 | 31687 | 4 | 1 |
8185 | 58871 | 35424 | 4 | 1 |
13972 | 87954 | 11549 | 4 | 1 |
11243 | 54778 | 12552 | 4 | 1 |
4635 | 39825 | 19494 | 4 | 1 |
10063 | 49536 | 12195 | 4 | 1 |
8426 | 60102 | 13787 | 4 | 1 |
7436 | 49139 | 22356 | 4 | 1 |
11747 | 51052 | 4553 | 4 | 1 |
15397 | 70500 | 12025 | 4 | 1 |
6842 | 54894 | 16217 | 4 | 1 |
9678 | 60570 | 4106 | 4 | 1 |
12852 | 57625 | 31228 | 4 | 1 |
10114 | 56956 | 25907 | 4 | 1 |
8496 | 61400 | 1093 | 4 | 1 |
6689 | 50532 | 17106 | 4 | 1 |
15696 | 72774 | 17793 | 4 | 1 |
9841 | 69981 | 21607 | 4 | 1 |
12529 | 66891 | 17689 | 4 | 1 |
10210 | 67431 | 19995 | 4 | 1 |
8868 | 64782 | 14489 | 4 | 1 |
6426 | 38987 | 17864 | 4 | 1 |
11096 | 64867 | 5839 | 4 | 1 |
10086 | 50421 | 8689 | 4 | 1 |
2587 | 27076 | 17534 | 4 | 1 |
12492 | 51784 | 20284 | 4 | 2 |
8456 | 54135 | 22037 | 4 | 2 |
6801 | 53291 | 23342 | 4 | 2 |
6339 | 49804 | 34943 | 4 | 2 |
7802 | 52205 | 28579 | 4 | 2 |
9717 | 72841 | 22349 | 4 | 2 |
6026 | 46238 | 20165 | 4 | 2 |
5618 | 45938 | 10538 | 4 | 2 |
10217 | 77716 | 18516 | 4 | 2 |
8338 | 59711 | 7980 | 4 | 2 |
9048 | 42106 | 19786 | 4 | 2 |
4017 | 36462 | 9935 | 4 | 2 |
10906 | 53403 | 18177 | 4 | 2 |
15148 | 71290 | 6696 | 4 | 2 |
8830 | 66759 | 20972 | 4 | 2 |
8481 | 57616 | 28767 | 4 | 2 |
11358 | 76221 | 1373 | 4 | 2 |
10553 | 78202 | 5920 | 4 | 2 |
6969 | 55164 | 24795 | 4 | 2 |
13219 | 61171 | 21482 | 4 | 2 |
3543 | 34093 | 25969 | 4 | 2 |
7326 | 50647 | 10750 | 4 | 2 |
8458 | 59898 | 22940 | 4 | 2 |
11766 | 52884 | 25970 | 4 | 2 |
9908 | 73629 | 7112 | 4 | 2 |
Choose one of the following data sets to complete this assignment:
Consumer Food
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
Annual Food Spending ($) | Quantitative |
Annual Household Income | Quantitative |
Non mortgage household debt | Quantitative |
Region | qualitative |
Location: | qualitative |
Annual Food Spending ($) | Annual Household Income ($) | Non mortgage household debt ($) | |
Mean | 8966.065 | 55552.4 | 15604.175 |
Median | 8932 | 54957.5 | 16100.5 |
Standard Deviation | 3125.007986 | 14661.33212 | 8583.517421 |
Minimum | 2587 | 21647 | 0 |
Maximum | 17740 | 96132 | 36374 |
Range | 15153 | 74485 | 36374 |
Mean : Use the mean to describe the sample with a single value that represents the center of the data. Many statistical analyses use the mean as a standard measure of the center of the distribution of the data.
The median and the mean both measure central tendency. But unusual values, called outliers, affect the median less than they affect the mean. When you have unusual values, you can compare the mean and the median to decide which is the better measure to use. If your data are symmetric, the mean and median are similar.
Standard Deviation: Use the standard deviation to determine how spread out the data are from the mean. A higher standard deviation value indicates greater spread in the data.
Range: Use the range to understand the amount of dispersion in the data. A large range value indicates greater dispersion in the data.
Annual Food Spending ($) Annual Household Income ($) Non mortgage household debt ($) Region: 1 =...
. 1/3 points | Previous AnswersPriviteraStats2 4.E.015 A sociologist records the annual household income (in thousands of dollars) among a sample of families living in a high-crime neighborhood. Locate the lower, median, and upper quartiles for the times listed below. Hint: First arrange the data in numerical order. lower quartile median 38 thousand dollars upper quartile X thousand dollars thousand dollars 23 40 21 45 44 38 34 38 31 54 Arrange the data in numeric order before finding the...
1. Find the mean, the variance and standard deviation. The number of dogs per household in a small town. Dog: 0, 1, 2, 3, 4, 5 P( x): 686, 195, 077, 022, 013. 007 2. Score (x): 1, 2, 3, 4, 5 Frequencies: 24, 33,42, 30, 21 A. Construct a discrete probability distribution B. Find the mean, the variance and the standard deviation.
Find the mean, mode, median, variance, Standard Deviation, and range of the following data: 1 4 2 2 5 1 3 6 3 4 7 4 5 8 1
1. GDP - annual debt 2. government spending - tax revenue >0 3.government spending - tax revenue <0 4. annual debt/GDP 5 annual deficit/GDP 6. total debt - debt held by us households and institutions ================================================== A budget deficit is government spending in excess of what? A.. tax revenues B. real GDP C. household spending D. consumption ================================================ What would happen to the cyclical deficit if the GDP growth rate jumped from 2 percent to 4 percent? A.decrease in deficit...
Question 1. a. What is the average rating for all CBC movies? How about ABN movies and BBS movies? b. Include a table that shows the average and the other descriptive statistics (using the data analysis tool pack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table. c. Comment on which network is doing best. | Η 1 CBC 15.6 AB DE BBS...
30 The manager of the local Walmart Superright is studying the number of items purchased by customers in the evening hours. Listed below is the number of items for a sample of 30 customers. 15 12 5 8 4 6 6 7 11 9 8 14 9 12 5 4 10 6 18 10 6 10 11 5 10 9 13 12 13 5 2 01:40:06 Click here for the Excel Data File a. Find the mean and the median...
1.) Find the mean, the median, and the mode for the number of vehicles owned in a survey of 52 households. x 0 1 2 3 4 5 6 7 f 2 12 15 11 6 3 1 2 2.) Find the range, the variance, and the standard deviation for the sample represented by the data frequency table. x -1 0 1 4 f 1 1 3 1 3.) A random sample of 49 invoices for repairs at an automotive...
Gross Sales Distance to Neighborhood MedianNeighborhood NeighborhoodNumber Businesses Median Age Parking Dummy Variable Free Parking Nearby Location Day) University (mi) Residential Population within 5 mi 3 5 0 1 2 2 NeighborhoodNumber Businesses Parking Dummy Variable Free Parking Nearby Location(1 Day) University (mi) Residential Population within 5 mi 10400 9 1 Excel Assignment #2: Multiple Regression The Food Truck Case Study Overview and Objectives This assignment examines the case of a new food truck and the role that location plays...
Complete parts (a) and (b) below. The number of dogs per household in a small town Dogs: 0 1 2 3 4 5 Probability: 0.677 0.203 0.079 0.023 0.013 0.005 (a) Find the mean, variance, and standard deviation of the probability distribution. Find the mean of the probability distribution. μ= (Round to one decimal place as needed.)
Lab Exercise #15 Assignment Overview This lab exercise provides practice with Pandas data analysis library. Data Files We provide three comma-separated-value file, scores.csv , college_scorecard.csv, and mpg.csv. The first file is list of a few students and their exam grades. The second file includes data from 1996 through 2016 for all undergraduate degree-granting institutions of higher education. The data about the institution will help the students to make decision about the institution for their higher education such as student completion,...