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!

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.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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