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
An Arts group holds a raffle.  Each raffle ticket costs $2 and the raffle consists of 2500 tickets.  The prize is a vacation worth $3,000.    a. Determine your expected value if you buy one ticket.     b. Determine your expected value if you buy five tickets.     How much will the Arts group gain or lose if they sell all the tickets?
Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy.        Consider the following game.  It costs $3 each time you roll a six-sided number cube.  If you roll a 6 you win $15.  If you roll any other number, you receive nothing.   a) Find the expected value of the game.         b) If you play this game many times, will you expect to gain or lose money?
= 12:02 WeBWorK / 2024 Fall Rafeek MTH23 D02 / 9.2 Testing the Mean mu / 3 38 WEBWORK Previous Problem Problem List Next Problem 9.2 Testing the Mean mu: Problem 3 (1 point) Test the claim that the population of sophomore college students has a mean grade point average greater than 2.2. Sample statistics include n = 71, x = 2.44, and s = 0.9. Use a significance level of a = 0.01. The test statistic is The P-Value is between : The final conclusion is < P-value < A. There is sufficient evidence to support the claim that the mean grade point average is greater than 2.2. ○ B. There is not sufficient evidence to support the claim that the mean grade point average is greater than 2.2. Note: You can earn partial credit on this problem. Note: You are in the Reduced Scoring Period. All work counts for 50% of the original. Preview My Answers Submit Answers You have attempted this problem 0 times. You have unlimited attempts remaining. . Oli wwm01.bcc.cuny.edu

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