Managerial Decision Making - Statistics(Applied Managerial Concepts), statistics homework help

User Generated

Zhapuxva

Mathematics

Description

I need help with the assignment below. All instructions are listed below. DO NOT ACCEPT IF YOU DO NOT UNDERSTAND OR CANNOT MEET THE DEADLINE( I already had a tutor waste time by doing this) I have attached the necessary documents and gave the link for the BI Software. I need a Power Point Presentation approximately 5-6 slides with speaker notes (approximately 200 words per slide)plus a title and reference slide:

For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then download the software. Complete the following steps to begin:

  • Step 1: Download the BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download. Here is the link https://public.tableau.com/s/

Consider the following scenario:

The National Sales meeting is approaching. Each regional sales manager has to do a short presentation for the marketing department that highlights how the consumers in their territory are different from those in the total United States. You are still working with the local regional sales manager. Complete the following:

  • Attached are the reports for the United States. This file contains reports generated from a marketing organization's Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire United States.
  • Attached are the reports for zip code 60614. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the U.S. zip code 60614.
  • Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page memo explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in this data.
  • Use the business intelligence software to depict information from these reports.
  • Prepare a presentation of 5–6 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least one graph and a headline that summarizes a key takeaway from the graph. The last page should contain at least 3 questions that you would want answered based on what you've seen in this comparison.

For assistance with the usage of Tableau for analysis and reporting, review and use the following instructions. This should be helpful if you are having problems with the software usage or with problems with the data:

Instructions to Create Bar Graph in Tableau

  1. Download Business Intelligence Software.
  2. Create your Tableau Public Account.
  3. Click the download link for the zip code (60614) file (file will open in Excel).
  4. Click the download link for the US file (file will open in Excel).
  5. The following are some options:
    1. Create separate demographical worksheets. For example: Education Attainment File - Worksheet (include both Zip Code and U.S. data); Household Income (include Zip Code and U.S. data)
      • See a sample of the file available with column headings and extraneous blanks.

Household Income

Chicago

U.S.

1980

1990

1980 to 1990

2000

1990 to 2000

1980

Median Household Income

18,438

41,227

1.236

69,311

0.681

16,902

Average household Income

24,245

67,607

1.788

114,615

0.695

20,382

Per Capita Income

13,564

38,518

1.84

63,791

0.656

7,321

  • See a sample of the file available with column headings and extraneous blanks.

2000 Educational Attainment

U.S.

Chicago

College: Associates Degree

6.3%

1.9%

College: Bachelor's Degree

15.5%

44.2%

College: Graduate Degree

8.9%

34.0%

College: Some College, no Degree

21.1%

8.7%

School: 9th to 11th grade, no diploma

12.1%

3.2%

School: Grade K-9

6.1%

2.0%

School: High School Graduate

28.6%

5.6%

    1. Create a file with data organized without extraneous rows and columns but including headings.
    2. The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
    3. Note in the real situation, when using BI software, you will want to ensure your data are clean and you have similar data in your files.
  1. Save the file(s) on your computer.
  2. Open Tableau. Then do a File > Open > Open your saved file.
  3. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
  4. Under Measures (on left), you should see Chicago and U.S. Click on U.S. and pull it into rows at the top of the screen. Then click on Chicago and pull it over into rows.
  5. Under Dimensions on the left, you should see Household Income. Click on Household Income and pull it into column.
  6. Now in the second column from the left, you should see measures.
  7. In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
  8. To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
  9. When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in tableau public.)
  10. After the file is saved, open the .png file, and edit or copy the graph.
  11. Open your PowerPoint file, then paste (special) it on the slide. You can adjust the size.
  12. Repeat the same in Tableau opening of any other prepped and cleaned file.

Note: Measure values are your number fields; measure names are the descriptors.

Unformatted Attachment Preview

Date: March 3, 2006 Current Geography Selection: Entire US: Entire US General Summary Report US Census 2000 Basic Variables 2000 Educational Attainment College: Associates Degree College: Bachelor's Degree College: Graduate Degree College: Some College, No Degree School: 9th to 11th grade no diploma School: Grade K - 9 School: High School Graduate 6,32% 15,54% 8,86% 21,05% 12,05% 6,11% 28,63% 2000 Marital Status Divorced Never Married Now Married Separated Widowed 9,75% 27,10% 51,13% 5,40% 6,63% US Census 2000 Race and Ethnicity Total Population: Race Hispanic Ethnicity: Race American Indian, Eskimo, Aleut Population Asian Black Population 0,90% 3,60% 12,30% American Indian/Alaska Native Alone Asian Alone Black Alone 1,20% 0,30% 2,00% Hispanic Ethnicity 12,50% Native Hawaiian/Other Pacific Islander Alone 0,10% Native Hawaiian and Other Pacific Islander Alone Not or Latino Other Population Two or More Races White Population 0,10% 87,50% 5,50% 2,40% 75,10% Some Other Race Two or More races White Alone Hispanic Ethnicity Population 42,20% 6,30% 47,90% 3504 US Census 2000 Occupation and Employment 2000 Means of Transportation to Work Bicycle Bus or trolley bus Carpooled Drove alone Ferryboat Motorcycle Other means Railroad Streetcar or trolley car Subway or elevated Taxicab Walked Worked at home Workers Age 16+ 2000 Travel Time to Work in Minutes Median Travel Time To Work 0 to 5 5 to 9 10 to 14 15 to 19 20 to 24 25 to 29 30 to 34 35 to 39 40 to 44 45 to 59 60 to 89 90 or more Worked at home 2150,00% 3,30% 10,70% 14,50% 15,30% 14,00% 5,60% 12,80% 2,50% 3,20% 7,20% 5,00% 2,70% 3,30% 71.787.347 Male Householder 3.776.997 79.134.868 5.428.325 Male HHldr, no wife present, own children < 18 Female Householder 2.190.989 2.685.682 Female HHldr, no husband present, own children < 18 7.561.874 0,38% 2,50% 12,20% 75,70% 0,00% 0,10% 0,70% 0,50% 0,10% 1,50% 0,20% 2,90% 3,30% 45551 US Census 2000 Family Status: Family Households Family Households Natural Born or Adopted Children in Family Hhlds Grandchildren in Family Hhlds Step Children in Family Hhlds 4.258.524 Married Couple Family Married Couple Family w/ Children < 18 54.493.232 24.835.505 Married Couple Family w/ no own Children < 18 29.657.727 Date: March 3, 2006 Current Geography Selection: Entire US Census Trend 1980 to 2000 Summary Report Basic Variables Population Percent Female Percent Male 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 224.811.135 248.710.012 10,60% 281.421.906 13,20% 51,50% 51,30% 10,20% 50,90% 12,50% 48,50% 48,70% 11,10% 49,10% 13,90% 79.887.387 91.947.641 15,10% 105.480.101 14,70% 2,75 2,63 -4,20% 2,59 -1,40% 193.665.964 203.905.540 5,30% 231.374.718 13,50% 5.417.823 6.697.345 23,60% 7.778.633 16,10% 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 Median Household Income $16.902 $30.102 78,10% $42.257 40,40% Average Household Income $20.382 $38.464 88,70% $56.643 47,30% Total Households Average Household Size Family Population Group Quarters Population Household Income Per Capita Income $7.321 $14.381 96,40% $21.231 47,60% $ 0 - $9,999 23.151.917 14.160.538 -38,80% 10.061.842 -28,90% $ 10,000 - $14,999 12.228.204 8.114.324 -33,60% 6.653.726 -18,00% $ 15,000 - $19,999 11.292.020 8.091.126 -28,30% 6.597.532 -18,50% $ 20,000 - $29,999 9.945.771 15.439.727 55,20% 13.729.008 -11,10% $ 30,000 - $39,999 12.617.264 13.358.162 5,90% 12.946.852 -3,10% $ 40,000 - $49,999 3.359.065 10.221.806 204,30% 11.203.306 9,60% $ 50,000 - $74,999 3.591.660 13.795.934 284,10% 20.529.242 48,80% $ 75,000 + 3.719.547 8.754.151 135,40% 23.758.288 171,40% $ 75,000 - $99,999 2.578.079 4.711.982 82,80% 10.793.156 129,10% $100,000 + 1.141.468 4.042.169 254,10% $100,000 - $124,999 $125,000 - $149,999 $150,000 + 12.965.132 220,70% 1.834.823 5.488.333 199,10% 763.165 2.654.858 247,90% 1.444.181 4.821.941 233,90% Race and Ethnicity 2000 Percent Change 1990 to 2000 42,10% 2.475.956 26,40% 112,00% 10.641.833 46,40% 45,80% 15.359.073 56,70% 29.986.018 13,80% 34.658.190 15,60% 199.686.676 22.353.238 6,90% 53,80% 211.460.626 35.305.818 5,90% 57,90% 1980 1990 Percent Change 1980 to 1990 2000 Percent Change 1990 to 2000 Owner Occupied Housing 51.428.015 59.025.095 14,80% 69.815.753 18,30% Renter Occupied Housing 28.459.214 32.922.614 15,70% 35.664.348 8,30% 1980 1990 American Indian, Eskimo, Aleut 1.378.738 1.958.777 Asian 3.429.040 7.270.823 Other 6.726.165 9.804.230 Black 26.338.642 186.878.591 14.538.161 White Hispanic Ethnicity Percent Change 1980 to 1990 Housing Units Date: March 3, 2006 Current Geography Selection: Entire US: Entire US Occupation and Employment Summary Report Employment Not in Labor Force 1990 2000 66.603.437 34,70% 78.319.195 36,10% 125.216.716 65,30% 138.829.294 63,90% 115.716.133 92,40% 129.728.865 93,40% Unemployed 7.780.384 6,20% 7.947.452 5,70% In Armed Forces 1.706.113 0,90% 1.152.977 0,80% In Labor Force Employed 2000 Census Transportation, Industry and Occupation Means of Transportation to Work Workers Age 16+ Travel Time to Work 130.881.842 Median Travel Time To Work in Minutes 21 Bicycle 0,40% 0 to 5 3,30% Bus or trolley bus 2,50% 5 to 9 10,70% Carpooled 12,20% 10 to 14 14,50% Drove alone 75,70% 15 to 19 15,30% Ferryboat 0,00% 20 to 24 14,00% Motorcycle 0,10% 25 to 29 5,60% Other means 0,70% 30 to 34 12,80% Railroad 0,50% 35 to 39 2,50% Streetcar or trolley car 0,10% 40 to 44 3,20% Subway or elevated 1,50% 45 to 59 7,20% Taxicab 0,20% 60 to 89 5,00% Walked 2,90% 90 or more 2,70% Worked at home 3,30% Worked at home 3,30% Employment by Industry Occupation Accommodation and food services Administrative and support and waste management service 6,10% 3,40% Aircraft and traffic control occupations Architects surveyors cartographers and engineers Agriculture forestry fishing and hunting 1,50% Arts design entertainment sports and media occupation 1,90% Arts entertainment and recreation 1,80% Building & grounds cleaning & maintenance occupat 3,30% Construction 6,80% Business operations specialists 2,10% Educational services 8,80% Community and social services occupations 1,50% Finance and insurance 5,00% Computer and mathematical occupations 2,40% Construction trades workers 4,70% Drafters engineering and mapping technicians 0,60% Health care and social assistance Information 11,10% 3,10% 0,10% 1,50% Management of companies and enterprises Manufacturing 0,10% 14,10% Education training and library occupations 5,60% Extraction workers 0,10% Mining 0,40% Farmers and farm managers 0,60% Other services (except public administration) 4,90% Farming fishing and forestry occupations 0,70% Professional scientific and technical services 5,90% Financial specialists 2,20% 4,80% Fire fighting prevention and law enforcement workers 1,20% 1,90% Food preparation and serving related occupations 4,80% Health diagnosing and treating practitioners and tech 3,20% Public administration Real estate and rental and leasing Retail trade 11,70% Transportation and warehousing 4,30% Health technologists and technicians 1,40% Utilities 0,90% Healthcare support occupations 2,00% Wholesale trade 3,60% Installation maintenance and repair occupations 3,90% Personal care and service occupations 2,80% Legal occupations 1,10% Life physical and social science occupations 0,90% Management occupations except farmers and farm manage 8,50% Material moving workers 2,50% Motor vehicle operators 2,90% Office and administrative support occupations 15,30% Production 8,40% Protective Service Occupations 0,80% Rail water and other transportation occupations Sales and related occupations 0,30% 11,20% Supervisors construction and extraction workers 0,70% Supervisors transportation and material moving worker 0,20% Date: March 3, 2006 Current Geography Selection: Entire US: Entire US Income Summary Report 2000 Census Household Income by Type Total Households 105.480.101 Average Household Income $56.643 Total Population 281.421.906 Median Household Income $42.257 Total Workers 130.881.842 Per Capita Household Income $21.587 Income by Type: Earnings $ 1 to $2,499 or less Household Income Percents $ 0 - $9,999 9,54% $ 2,500 to $4,999 10.621.378 7.953.137 $ 10,000 - $14,999 6,31% $ 5,000 to $7,499 8.124.698 $ 15,000 - $19,999 6,25% $ 7,500 to $9,999 6.504.581 $ 20,000 - $24,999 6,57% $ 10,000 to $12,499 9.597.527 $ 25,000 - $29,999 6,44% $ 12,500 to $14,999 6.201.326 $ 30,000 - $34,999 6,37% $ 15,000 to $17,499 8.302.907 $ 35,000 - $39,999 5,91% $ 17,500 to $19,999 6.179.510 $ 40,000 - $44,999 5,65% $ 20,000 to $22,499 9.086.198 $ 45,000 - $49,999 4,97% $ 22,500 to $24,999 5.644.521 $ 50,000 - $59,999 9,04% $ 25,000 to $29,999 12.996.782 $ 60,000 - $74,999 10,43% $ 30,000 to $34,999 11.366.211 $ 75,000 - $99,999 10,23% $ 35,000 to $39,999 9.219.670 $100,000 - $124,999 5,20% $ 40,000 to $44,999 7.744.095 $125,000 - $149,999 2,52% $ 45,000 to $49,999 5.200.969 $150,000 - $199,999 2,20% $ 50,000 to $54,999 5.563.669 $200,000 + 2,37% $ 55,000 to $64,999 6.146.281 $ 65,000 to $74,999 2.041.290 $ 75,000 to $99,999 2.191.536 $100,000 or more 1.850.632 HH Income By Age of Householder
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

there you go buddy

Name
Course
Professor’s Name
Date



60614 and United States
◦ Study conducted same time periods (1980-1990
and 1990-2000)
◦ Use of qualitative and quantitative information



60614
◦ Smaller scale used



United States
◦ Larger scale used



Margin of error:
◦ For instance, – add or subtract 10, which could alter
every subject inside a variable by either increasing or
decreasing its value.





The capacity of making informed choices on the
premise of old data contrasts.
The reasonableness of utilizing aggregate
populace demographical test instead of looking
at demographical information by state or region.

$200,000 +

$150,000 - $199,999

$125...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags