Question

Please Solve on excel DATA workbook.( I HAVE ATTACHED THE DATA FOR EACH QUESTION- PLEASE ANSWER ON EXCEL DOCUMENT)

Xr02-62 A sample of 200 people who had purchased food at the concession stand at Yankee Stadium was asked to rate the quality of the food. The responses are as follows:

Poor

Fair

Good

Very good

Excellent Answer More than 40% rate the food as less than good. Draw a graph that describes the data. What does the graph tell you?

Rating

3

2

1

1

2

3

2

3

3

2

3

3

3

2

2

2

4

2

2

3

1

3

3

3

3

3

3

3

3

3

4

2

3

2

1

2

5

1

3

4

3

5

3

3

3

1

2

3

2

3

3

2

3

2

3

3

3

2

2

2

4

2

3

2

3

4

3

3

3

3

4

4

3

3

2

3

3

1

2

1

3

3

3

3

3

1

4

4

4

1

1

3

2

1

3

3

1

1

2

2

2

2

3

4

1

2

3

4

1

1

2

5

2

3

1

2

3

3

1

1

2

3

3

3

3

3

2

3

3

2

3

3

3

2

3

4

3

2

3

2

3

3

4

1

2

1

2

2

3

2

2

1

3

1

3

2

1

2

4

3

3

3

3

3

2

3

2

5

3

1

4

2

3

2

1

3

5

2

2

1

3

3

1

1

3

2

2

3

4

3

3

3

3

4

2

3

3

3

4

4

Answer 1