![Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337115186/9781337115186_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?
- Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forward2 (VaR and ES) Suppose X1 are independent. Prove that ~ Unif[-0.5, 0.5] and X2 VaRa (X1X2) < VaRa(X1) + VaRa (X2). ~ Unif[-0.5, 0.5]arrow_forward8 (Correlation and Diversification) Assume we have two stocks, A and B, show that a particular combination of the two stocks produce a risk-free portfolio when the correlation between the return of A and B is -1.arrow_forward
- 9 (Portfolio allocation) Suppose R₁ and R2 are returns of 2 assets and with expected return and variance respectively r₁ and 72 and variance-covariance σ2, 0%½ and σ12. Find −∞ ≤ w ≤ ∞ such that the portfolio wR₁ + (1 - w) R₂ has the smallest risk.arrow_forward7 (Multivariate random variable) Suppose X, €1, €2, €3 are IID N(0, 1) and Y2 Y₁ = 0.2 0.8X + €1, Y₂ = 0.3 +0.7X+ €2, Y3 = 0.2 + 0.9X + €3. = (In models like this, X is called the common factors of Y₁, Y₂, Y3.) Y = (Y1, Y2, Y3). (a) Find E(Y) and cov(Y). (b) What can you observe from cov(Y). Writearrow_forward1 (VaR and ES) Suppose X ~ f(x) with 1+x, if 0> x > −1 f(x) = 1−x if 1 x > 0 Find VaRo.05 (X) and ES0.05 (X).arrow_forward
- Joy is making Christmas gifts. She has 6 1/12 feet of yarn and will need 4 1/4 to complete our project. How much yarn will she have left over compute this solution in two different ways arrow_forwardSolve for X. Explain each step. 2^2x • 2^-4=8arrow_forwardOne hundred people were surveyed, and one question pertained to their educational background. The results of this question and their genders are given in the following table. Female (F) Male (F′) Total College degree (D) 30 20 50 No college degree (D′) 30 20 50 Total 60 40 100 If a person is selected at random from those surveyed, find the probability of each of the following events.1. The person is female or has a college degree. Answer: equation editor Equation Editor 2. The person is male or does not have a college degree. Answer: equation editor Equation Editor 3. The person is female or does not have a college degree.arrow_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)