Question

Annual Food Spending ($) Annual Household Income           ($) Non mortgage household debt ($) Region:   1 =...

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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.

Add a comment
Know the answer?
Add Answer to:
Annual Food Spending ($) Annual Household Income           ($) Non mortgage household debt ($) Region:   1 =...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • . 1/3 points | Previous AnswersPriviteraStats2 4.E.015 A sociologist records the annual household income (in thousands...

    . 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...

    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...

    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...

    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...

    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...

    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...

    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...

  • Excel Assignment #2: Multiple Regression The Food Truck Case Study Overview and Objectives This a...

    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...

    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...

    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,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT