Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Needs to be done on excel 2.2.3 Fifteen fourth graders were asked how many blocks they lived from school. The results are displayed in the

Needs to be done on excel image text in transcribed
2.2.3 Fifteen fourth graders were asked how many blocks they lived from school. The results are displayed in the following graph. 10 11 12 (prelim 1) use the graph to create a frequency table (prelim 2 Plot the data as a frequency polygon" (a.k.a. line graph: in Excel, this is a scatter plot with straight line option) (prelim 3) Describe the shape of the graph (roughly bell shaped, exponential, uniform or other roughly symmetric, night skew or left skew). Use Excel to calculate the following. Do so in a way so that if the data changes, then the calculations are automatically updated. Unfortunately, it is not easy to make your answers in the textbox also automatically update.) (a) What is the maximum number of blocks any student lives from school? (b) What is the minimum number of blocks? (c) How many students live less than 5 blocks from school? (d) How many students live more than 4 blocks from school

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management An Organizational Perspective

Authors: Richard T. Watson

1st Edition

0471305340, 978-0471305347

More Books

Students also viewed these Databases questions

Question

2. How does the auditory system process pitch and intensity?

Answered: 1 week ago

Question

11. Are your speaking notes helpful and effective?

Answered: 1 week ago

Question

The Goals of Informative Speaking Topics for Informative

Answered: 1 week ago