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
This battle room is focused on entry level tasks for a network analyst where you will be given trials and reconnaissance, sensor tuning, log aggregation, SIEM queries, and network analysis.   For this week’s project, complete the following tasks:   From your Project Ares portal, LOG IN Click on LAUNCH GAME. Select the region NORTH AMERICA Click on Battle School Under the BATTLE SCHOOL pop-up window, click on START TRAINING. Under the BATTLE ROOMS tile, click on ENTER. Under the NETWORK ANALYST tile, click on PLAY. Wait for the Battle Room to load. While loading, the BATTLE ROOM button will display red. Once the Battle Room is loaded, the BATTLE ROOM button will turn yellow and the center of the disk display will indicate CONNECTED. Click on the BATTLE ROOM button to enter the Battle Room. Below the TASKS folder, make sure you click on INSTRUCTIONS to download the Network Analyst Fundamentals material. In the Battle Room, under the TASKS menu select task INTRUSION DETECTION. Complete…
Create a relationship between the common field (Technician Number) of the two tables. Make sure that each client must have 1 and only 1 technician assigned, and each technician can have multiple clients. 2. Create a query to show the Client Number, Client Name, Billed, Paid for clients in Anderson city. Save the query. 3. Create a query to show the Technician Number, Last Name, First Name, YTD Earnings for technicians whose Hourly Rate is greater than or equal to 30. Save the query. 4. Create a query to show Client Number, Client Name, Billed, Paid for clients whose technician number is 22 and whose Billed is over 300. Save the query. 5. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23. Save the query. 6. Create a query to show the Technician Number, Last Name, First Name, Client Number, Client Name for clients whose technician number 23 or 29. Save the query Help please Microsoft office access
Dijkstra's Algorithm (part 1).  Consider the network shown below, and Dijkstra’s link-state algorithm. Here, we are interested in computing the least cost path from node E (note: the start node here is E) to all other nodes using Dijkstra's algorithm. Using the algorithm statement used in the textbook and its visual representation, complete the "Step 0" row in the table below showing the link state algorithm’s execution by matching the table entries (i), (ii), (iii), and (iv) with their values.  Write down your final [correct] answer, as you‘ll need it for the next question.

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
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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