Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 44SE

SAT Scores. The SAT is a standardized test used by many colleges and universities in their admission decisions. More than one million high school students take the SAT each year. The current version of the SAT includes three parts: reading comprehension, mathematics, and writing. A perfect combined score for all three parts is 2400. A sample of SAT scores for the combined three-part SAT are as follows:

Chapter 2, Problem 44SE, SAT Scores. The SAT is a standardized test used by many colleges and universities in their admission

  1. a. Show a frequency distribution and histogram. Begin with the first class starting at 800 and use a class width of 200.
  2. b. Comment on the shape of the distribution.
  3. c. What other observations can be made about the SAT scores based on the tabular and graphical summaries?

a.

Expert Solution
Check Mark
To determine

Construct the frequency distribution and histogram for the data.

Answer to Problem 44SE

The frequency distribution is tabulated below:

ClassTallyFrequency
800-999|1
1000-1199|||3
1200-1399|||||6
1400-1599||||||||10
1600-1799||||||7
1800-1999||2
2000-2199|1
Total 30
  • Output using EXCEL is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 2, Problem 44SE

Explanation of Solution

Calculation:

The data represent the sample of SAT scores for the combined three part sat scores.

The frequencies are calculated using the tally mark and the method of grouping is used because the range of the data is from 800 to 2,199. Here, the number of times each class level repeats is the frequency of that particular class.

  • From the given data set, it is given that the class should be approximately started with the class of 800 and with the class width of 200.
  • Make a tally mark for each value in the corresponding class and continue for all the values in the data.
  • The number of tally marks in each class represents the frequency f of that class.

Similarly, the frequency of the remaining classes for the data set is given below:

ClassTallyFrequency
800-999|1
1,000-1,199|||3
1,200-1,399|||||6
1,400-1,599||||||||10
1,600-1,799||||||7
1,800-1,999||2
2,000-2,199|1
Total 30

Software procedure:

Step-by-step procedure to draw the frequency histogram chart using EXCEL software:

  • In Excel sheet, enter Class in one column and Frequency in another column.
  • Select the data and then choose Insert > Insert Column Bar Charts.
  • Select Clustered Column Under More Column Charts.
  • Double click the bars
  • In Format Data Series, enter 0 in Gap Width under Series Options.

b.

Expert Solution
Check Mark
To determine

Comment the shape of the distribution.

Answer to Problem 44SE

The distribution of sat score is approximately symmetric.

Explanation of Solution

Symmetric distribution:

If the left and right sides of the distribution are approximately equal or mirror images of each other, then the distribution is symmetric distribution.

From the graph, it is observed that the left and right sides of the histogram are approximately equal. Hence, the shape of the distribution is a bell-shaped curve.

Thus, it can be concluded that the distribution is approximately symmetric.

c.

Expert Solution
Check Mark
To determine

Comment the observations of sat scores based on the tabular and graphical summary.

Explanation of Solution

From the data and the histogram, it is observed that approximately 33 percent of sat score (frequency about 10 of 30) lie between 1,400 and 1,599.

  • Moreover, the score less than 800 or greater than 2,200 are unusual, and the average value of sat scores is over 1,500.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
08:34 ◄ Classroom 07:59 Probs. 5-32/33 D ا. 89 5-34. Determine the horizontal and vertical components of reaction at the pin A and the normal force at the smooth peg B on the member. A 0,4 m 0.4 m Prob. 5-34 F=600 N fr th ar 0. 163586 5-37. The wooden plank resting between the buildings deflects slightly when it supports the 50-kg boy. This deflection causes a triangular distribution of load at its ends. having maximum intensities of w, and wg. Determine w and wg. each measured in N/m. when the boy is standing 3 m from one end as shown. Neglect the mass of the plank. 0.45 m 3 m
Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…
Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
How to make Frequency Distribution Table / Tally Marks and Frequency Distribution Table; Author: Reenu Math;https://www.youtube.com/watch?v=i_A6RiE8tLE;License: Standard YouTube License, CC-BY
Frequency distribution table in statistics; Author: Math and Science;https://www.youtube.com/watch?v=T7KYO76DoOE;License: Standard YouTube License, CC-BY
Frequency Distribution Table for Grouped/Continuous data | Math Dot Com; Author: Maths dotcom;https://www.youtube.com/watch?v=ErnccbXQOPY;License: Standard Youtube License