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
In addition to the in-school milk supplement program, the nurse would like to increase the use of daily vitamin supplements for the children by visiting homes and educating about the merits of vitamins. She believes that currently, about 50% of families with school-age children give the children a daily megavitamin. She would like to increase this to 70%. She plans a two-group study, where one group serves as a control and the other group receives her visits. How many families should she expect to visit to have 80% power of detecting this difference? Assume that drop-out rate is 5%.
A recent survey of 400 americans asked whether or not parents do too much for their young adult children. The results of the survey are shown in the data file. a) Construct the frequency and relative frequency distributions. How many respondents felt that parents do too much for their adult children? What proportion of respondents felt that parents do too little for their adult children? b) Construct a pie chart. Summarize the findings
The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque 23.3 Jacksonville 26.2 Phoenix 28.3 Atlanta 28.3 Kansas City 23.4 Pittsburgh 25.0 Austin 24.6 Las Vegas 28.4 Portland 26.4 Baltimore 32.1 Little Rock 20.1 Providence 23.6 Boston 31.7 Los Angeles 32.2 Richmond 23.4 Charlotte 25.8 Louisville 21.4 Sacramento 25.8 Chicago 38.1 Memphis 23.8 Salt Lake City 20.2 Cincinnati 24.9 Miami 30.7 San Antonio 26.1 Cleveland 26.8 Milwaukee 24.8 San Diego 24.8 Columbus 23.4 Minneapolis 23.6 San Francisco 32.6 Dallas 28.5 Nashville 25.3 San Jose 28.5 Denver 28.1 New Orleans 31.7 Seattle 27.3 Detroit 29.3 New York 43.8 St. Louis 26.8 El Paso 24.4 Oklahoma City 22.0 Tucson 24.0 Fresno 23.0 Orlando 27.1 Tulsa 20.1 Indianapolis 24.8 Philadelphia 34.2 Washington, D.C. 32.8 a. What is the mean commute time for…

Chapter 2 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 2.2 - 11. Consider the following data. Develop a...Ch. 2.2 - 12. Consider the following frequency...Ch. 2.2 - Construct a histogram for the data in exercise...Ch. 2.2 - Prob. 14ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications 17. A doctor’s office staff studied...Ch. 2.2 - NBA Total Player Ratings. CBSSports.com developed...Ch. 2.2 - Prob. 19ECh. 2.2 - CEO Time in Meetings. The London School of...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 24ECh. 2.2 - Best Paying College Degrees. Each year America.EDU...Ch. 2.2 - Prob. 26ECh. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - Daytona 500 Automobile Makes Average Speeds. The...Ch. 2.3 - Daytona 500 Average Speeds of Winners. The...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Household Income Levels. The following...Ch. 2.3 - 33. Each year Forbes ranks the world’s most...Ch. 2.3 - Prob. 34ECh. 2.3 - The U.S. Department of Energy's Fuel Economy...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Prob. 37ECh. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - Driving Speed and Fuel Efficiency. A study on...Ch. 2.4 - The DATAfile Snow contains average annual snowfall...Ch. 2.4 - Hypertension and Heart Disease. People often wait...Ch. 2.4 - Smartphones are mobile phones with Internet,...Ch. 2.4 - Store Managers Time Study. The Northwest regional...Ch. 2 - SAT Scores. The SAT is a standardized test used by...Ch. 2 - Median Household Incomes. The file MedianHousehold...Ch. 2 - State Populations. Data showing the population by...Ch. 2 - Startup Company Funds. According to the Wall...Ch. 2 - Complaints Reported to BBB. Consumer complaints...Ch. 2 - Stock Price Volatility. The term “beta” refers to...Ch. 2 - Education Level and Household Income. The U.S....Ch. 2 - Prob. 51SECh. 2 - Best Places to Work. Fortune magazine publishes an...Ch. 2 - Prob. 53SECh. 2 - Prob. 54SECh. 2 - Prob. 55SECh. 2 - Prob. 56SECh. 2 - Google has changed its strategy with regard to...Ch. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Motion Picture Industry The motion picture...Ch. 2 - Cincinnati, Ohio, also known as the Queen City,...Ch. 2 - Jon Weideman, first shift foreman for Cut-Rate...
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