![Modern Business Statistics with Microsoft Excel (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781285433301/9781285433301_largeCoverImage.gif)
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:
- a. Show a frequency distribution and histogram. Begin with the first class starting at 800 and use a class width of 200.
- b. Comment on the shape of the distribution.
- c. What other observations can be made about the SAT scores based on the tabular and graphical summaries?
a.
![Check Mark](/static/check-mark.png)
Construct the frequency distribution and histogram for the data.
Answer to Problem 44SE
The frequency distribution is tabulated below:
Class | Tally | Frequency |
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:
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:
Class | Tally | Frequency |
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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?
Chapter 2 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
- 9. The concentration function of a random variable X is defined as Qx(h) = sup P(x ≤ X ≤x+h), h>0. Show that, if X and Y are independent random variables, then Qx+y (h) min{Qx(h). Qr (h)).arrow_forward10. Prove that, if (t)=1+0(12) as asf->> O is a characteristic function, then p = 1.arrow_forward9. The concentration function of a random variable X is defined as Qx(h) sup P(x ≤x≤x+h), h>0. (b) Is it true that Qx(ah) =aQx (h)?arrow_forward
- 3. Let X1, X2,..., X, be independent, Exp(1)-distributed random variables, and set V₁₁ = max Xk and W₁ = X₁+x+x+ Isk≤narrow_forward7. Consider the function (t)=(1+|t|)e, ER. (a) Prove that is a characteristic function. (b) Prove that the corresponding distribution is absolutely continuous. (c) Prove, departing from itself, that the distribution has finite mean and variance. (d) Prove, without computation, that the mean equals 0. (e) Compute the density.arrow_forward1. Show, by using characteristic, or moment generating functions, that if fx(x) = ½ex, -∞0 < x < ∞, then XY₁ - Y2, where Y₁ and Y2 are independent, exponentially distributed random variables.arrow_forward
- 1. Show, by using characteristic, or moment generating functions, that if 1 fx(x): x) = ½exarrow_forward1990) 02-02 50% mesob berceus +7 What's the probability of getting more than 1 head on 10 flips of a fair coin?arrow_forward9. The concentration function of a random variable X is defined as Qx(h) sup P(x≤x≤x+h), h>0. = x (a) Show that Qx+b(h) = Qx(h).arrow_forward
- Suppose that you buy a lottery ticket, and you have to pick six numbers from 1 through 50 (repetitions allowed). Which combination is more likely to win: 13, 48, 17, 22, 6, 39 or 1, 2, 3, 4, 5, 6? barrow_forward2 Make a histogram from this data set of test scores: 72, 79, 81, 80, 63, 62, 89, 99, 50, 78, 87, 97, 55, 69, 97, 87, 88, 99, 76, 78, 65, 77, 88, 90, and 81. Would a pie chart be appropriate for this data? ganizing Quantitative Data: Charts and Graphs 45arrow_forward10 Meteorologists use computer models to predict when and where a hurricane will hit shore. Suppose they predict that hurricane Stat has a 20 percent chance of hitting the East Coast. a. On what info are the meteorologists basing this prediction? b. Why is this prediction harder to make than your chance of getting a head on your next coin toss? U anoiaarrow_forward
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)