2. As part of the marketing group at Pixar, you are asked to find out the...

Question

Question

2. As part of the marketing group at Pixar, you are asked to find out the age distribution of the audience of Pixars latest film. With the help of 10 of your colleagues, you conduct exit interviews by randomly selecting people to question at 20 different movie theaters. You ask them to tell you if they are younger than 6 years old, 6 to 9 years old, 10 to 14 years old, 15 to 21 years old, or older than 21 From 470 responses, you find out that 45 are younger than 6, 83 are 6 to 9 years old, 154 are 10 to 14, 18 are 15 to 21, and 170 are older than 21. For the age distribution: a) Make a frequency table. b) Make a relative frequency table.

Cor 4. From the age distribution data described in Exercise 2: a) Make a bar chart using counts on the y-axis. b) Make a relative frequency bar chart using percentagesd) Is on the y-axis. c) Make a pie chart. ure ing e) H

math Statistics-And-Probability

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

I creat frequency table and relative frequency table by hand and bar chart and pie char using excel

* Frequency table for age distriburion CIOSS fresueney 6 to g lo tol4 I5 to 2 214 4 5 9.3 15 4 Relative Frequeny table 4s- 145410 0.095145 83 4 6 6 S lo 15 o 17596 o 32166 0.0322-98 0 36172 1名 170 410 21く Fu Frequen Total Frequeny Relahve frequeno

To creat bar char using excel first select variable class and frequency then go to top ribbon and click on insert then column chart output is on screen.Same procedure for pie chart only you select pie.

D19 25 26 27 28 relative frequency 30 31 32 frequency(counts) 15 to 21 6%- 34 35 36 37 215 3G% 6 to 9 1896 10 to 14 51% 28 10 to 14 33% 41 15 to 21 4% 43 45 47 41Sheet1 Sheet2 Sheet3

Add a comment

Answer 2

Similar Homework Help Questions

2. As part of the marketing group at Pixar, you are asked to find out the...

2. As part of the marketing group at Pixar, you are asked to find out the age distribution of the audience of Pixar's latest film. With the help of 10 of your colleagues, you conduct exit interviews by randomly selecting people to question at 20 different movie theaters. You ask them to tell you if they are younger than 6 years old, 6 to 9 years old, 10 to 14 years old, 15 to 21 years old, or older than...
o w. ten komputer klad Odwołania Korespondencja Recenzja Widok PomocPowiedz mi, co chces 83 are 6...

o w. ten komputer klad Odwołania Korespondencja Recenzja Widok PomocPowiedz mi, co chces 83 are 6 to 9 years old, 154 are 10 to 14, 18 are 15 to 21, and 170 are older than 21. E age distribution make: a) a frequency table; b) a relative frequency table, c) a bar chart using counts on the y- d) a relative frequency bar chart using percentages on the y-axis; e) a pie chart. 9. As part of the marketing team...
A national survey asked people, "How often do you eat out for dinner. (a) Construct a...

A national survey asked people, "How often do you eat out for dinner. (a) Construct a relative frequency distribution of the data. instead of at home?" The frequencies were as follows. Complete parts (a) through (9) Response Relative Frequency Never Response Frequency Rarely Never 356 Sometimes Rarely 461 Most of the time Sometimes 929 Most of the time Always 410 Always 39 (Round to three decimal places as needed.) (b) What percentage of respondents answered "Always? DOOD (Round to one...

2) Part A In a class, the students are asked their age and the following answers...

2) Part A In a class, the students are asked their age and the following answers are obtained: 5; 7; 5; 9; 7; 7; 6; 9; 9; 9; 10; 12; 12; 7. Make a table of absolute frequency distribution (fi), cumulative frequency (Fi), Relative (h), Relative percentage (h,%) and cumulative relative (Hi) -------------------------------------------------------------------- Part B Now Respond: Respect the table of the previous problem, answer: A) How many students do they have at the most 8 years? B) What is...
A national survey asked people, "How often do you eat out for dinner, instead of at...

A national survey asked people, "How often do you eat out for dinner, instead of at home?" The frequencies were as foliows. Complete parts (a) through (g) D Frequency 171 418 Response Never Rarely Sometimes Most of the time Always 898 461 49 (a) Construct a relative frequency distribution of the data Relative Response Frequency Never Rarely Sometimes Most of the time Always (Round to three decimal places as needed.) (b) What percentage of respondents answered "Always"? 0% (Hound to...
A national survey asked people, "How often do you eat out for dinner. (a) Construct a...

A national survey asked people, "How often do you eat out for dinner. (a) Construct a relative frequency distribution of the data. instead of at home?" The frequencies were as follows. Complete parts (a) through (9) Relative Response Frequency Never Response Frequency Rarely Never 252 Sometimes Rarely 569 Most of the time Sometimes 966 Most of the time Always 371 Always (Round to three decimal places as needed.) 68 (b) What percentage of respondents answered "Always"? (Round to one decimal...

Consider a sample with 10 observations of 11, –3, 8, 8, 10, 1, –2, 13, 8,...

Consider a sample with 10 observations of 11, –3, 8, 8, 10, 1, –2, 13, 8, and –4. Use z-scores to determine if there are any outliers in the data; assume a bell-shaped distribution. (Round your answers to 2 decimal places. Negative values should be indicated by a minus sign.) The z-score for the smallest observation The z-score for the largest observation There are outliers or no outliers in the data. The historical returns on a portfolio had...
Consider a sample with 10 observations of 11, –3, 8, 8, 10, 1, –2, 13, 8,...

Consider a sample with 10 observations of 11, –3, 8, 8, 10, 1, –2, 13, 8, and –4. Use z-scores to determine if there are any outliers in the data; assume a bell-shaped distribution. (Round your answers to 2 decimal places. Negative values should be indicated by a minus sign.) The z-score for the smallest observation The z-score for the largest observation There are outliers or no outliers in the data. The historical returns on a portfolio had...
The frequency distribution table below represents the rents of 250 randomly selected apartments in Minneapolis. a)...

The frequency distribution table below represents the rents of 250 randomly selected apartments in Minneapolis. a) Using the information in the table below, draw a pie chart (by hand or with Excel). b) What is the probability that someone paid rent of $600 or more? The frequency distribution table below represents the rents of 250 randomly selected apartments in Minneapolis. a) Using the information in the table below, draw a pie chart (by hand or with Excel). b) What is...

The historical returns on a portfolio had an average return of 21 percent and a standard...

The historical returns on a portfolio had an average return of 21 percent and a standard deviation of 29 percent. Assume that returns on this portfolio follow a bell-shaped distribution. a. Approximately what percentage of returns were greater than 79 percent? (Round your answer to the nearest whole percent.) b. Approximately what percentage of returns were below –66 percent? (Round your answer to 1 decimal place.) ____________________________________________________________________________________________________________________________ The following relative frequency distribution was constructed from a population of 400. Calculate...

2. As part of the marketing group at Pixar, you are asked to find out the...

Homework Answers

Add Answer to:
2. As part of the marketing group at Pixar, you are asked to find out the...

Post as a guest

Earn Coins