Pivot Data Table - Multiple Expenditures

age 25 65 25 34 35 44 45 64 total result year region

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ,981 525,864 1,201,986 South West 68,675 318,051 332,488 413,792 877,614 2,010,620 65,994 225,310 255,045 333,473 613,558 1,493,380 Total Result 225,886 959,131 962,728 1,235,968 2,569,410 5,953,123 Year 2010-2011 Sum - Expenditures (million $) Age <25 >=65 25-34 35-44 45-64 Total Result Region Midwest Northeast 52,272 200,899 197,870 243,722 552,374 1,247,137 38,945 214,871 177,325 244,981 525,864 1,201,986 South West 68,675 318,051 332,488 413,792 877,614 2,010,620 65,994 225,310 255,045 333,473 613,558 1,493,380 Total Result 225,886 959,131 962,728 1,235,968 2,569,410 5,953,123 Year 2010-2011 Sum - Expenditures (million $) Age <25 >=65 25-34 35-44 45-64 Total Result Region Midwest Northeast 52,272 200,899 197,870 243,722 552,374 1,247,137 38,945 214,871 177,325 244,981 525,864 1,201,986 South West 68,675 318,051 332,488 413,792 877,614 2,010,620 65,994 225,310 255,045 333,473 613,558 1,493,380 Total Result 225,886 959,131 962,728 1,235,968 2,569,410 5,953,123 Year 2010-2011 Sum - Expenditures (million $) Age <25 >=65 25-34 35-44 45-64 Total Result Region Midwest Northeast 52,272 200,899 197,870 243,722 552,374 1,247,137 38,945 214,871 177,325 244,981 525,864 1,201,986 South West 68,675 318,051 332,488 413,792 877,614 2,010,620 65,994 225,310 255,045 333,473 613,558 1,493,380 Total Result 225,886 959,131 962,728 1,235,968 2,569,410 5,953,123 Sum - Expenditures (million $) Age <25 >=65 25-34 35-44 45-64 Total Result Year Region 2008-2009 2008-2009 Result 2010-2011 2010-2011 Result Total Result Midwest Northeast South West Midwest Northeast South West 58,585 37,393 72,807 62,155 230,940 52,272 38,945 68,675 65,994 225,886 456,826 201,053 201,938 305,779 194,920 903,690 200,899 214,871 318,051 225,310 959,131 1,862,821 202,563 155,010 324,873 270,636 953,082 197,870 177,325 332,488 255,045 962,728 1,915,810 256,155 252,800 455,705 342,941 1,307,601 243,722 244,981 413,792 333,473 1,235,968 2,543,569 585,523 570,618 865,420 595,707 2,617,268 552,374 525,864 877,614 613,558 2,569,410 5,186,678 1,303,879 1,217,759 2,024,584 1,466,359 6,012,581 1,247,137 1,201,986 2,010,620 1,493,380 5,953,123 11,965,704 1. In the Midwest, most expenditures were made from 2008-2009 by all age groups 2. The most expenditures in the Northeast were made by the age groups 35-44 and 45-64 from 2008-2009. 3. The age group 35-44 always has the highest expenditure in all regions from 2008-2009. 4. The amount of purchases throughout the age groups increses in the South and West from 2008- 2009 and only in the South from 2010-2011. 5. In both age ranges the most purchases were done within the age group of 45-64 in the South. Year 2010-2011 Sum - Expenditures (million $) Category Alcoholic beverages Apparel and services Cash contributions Education Entertainment Food Health care Housing Miscellaneous Personal care products and services Personal insurance and pensions Reading Tobacco products and smoking supplies Transportation Total Result Region Midwest 10,319 41,414 44,151 30,364 68,322 160,000 93,078 401,144 20,718 14,768 142,691 3,035 10,086 207,047 1,247,137 Northeast 11,404 44,623 36,422 36,241 59,897 151,785 72,677 431,885 19,824 13,753 131,132 2,847 8,232 181,264 1,201,986 South West 15,852 69,679 72,516 30,772 105,293 260,013 138,619 667,889 30,715 26,226 217,046 3,742 17,681 354,577 2,010,620 15,295 53,454 51,025 31,892 76,512 193,434 89,353 529,830 27,432 19,255 166,060 3,476 7,355 229,007 1,493,380 Total Result 52,870 209,170 204,114 129,269 310,024 765,232 393,727 2,030,748 98,689 74,002 656,929 13,100 43,354 971,895 5,953,123 Year Sum - Expenditures (million $) Sub-Category Household furnishings and equipment Household furnishings and equipment Result Total Result - all - Age <25 >=65 25-34 35-44 45-64 Region Midwest Northeast 3,373 13,396 12,798 15,504 34,156 79,227 79,227 South 2,013 12,119 9,157 13,461 31,186 67,936 67,936 West 4,623 20,047 21,202 28,456 55,981 130,309 130,309 4,328 14,243 15,682 19,917 38,461 92,631 92,631 Total Result 14,337 59,805 58,839 77,338 159,784 370,103 370,103 Observation - The region in which most sales are made for Pier 1 is the South. - The age range in which most sales are made from for Pier 1 is 45-64 years old. - The lowest expenditures are made by consumers under 25 in the midwest...
View Full Document

This homework help was uploaded on 04/09/2014 for the course INSY 2299 taught by Professor Professoryounge.lee during the Fall '12 term at Fordham.

Ask a homework question - tutors are online