a.
Construct the histogram for body mass of the 50 difference bird species based on the class intervals.
Identify whether transformation of the data is desirable or not.
a.
Answer to Problem 107E
The histogram for body mass of the 50 difference bird species based on the class intervals is given below:
The transformation of the data is desirable.
Explanation of Solution
Calculation:
It is given that the body mass of the 50 different bird species.
Software procedure:
Step-by-step procedure to construct the histogram using the MINITAB software:
- Choose Graph > Histogram.
- Select Simple, and then click OK.
- In Graph variables, enter the corresponding column of Body mass.
- Click OK.
- Double click on x axis and select Binning.
- Choose Cutpoint and enter Number of intervals as 9.
- Enter 5 10 15 20 25 30 40 50 100 500 under Midpoint/Cutpoint positions.
- Click Ok.
From the histogram, it can be observed that most of the data values fall towards the left of the distribution extending the tail towards the right indicating that the distribution of body mass is positively skewed. Thus, for making the data symmetric a transformation is needed.
Hence, the transformation of the data is desirable.
b.
Construct the histogram by transforming the data using logarithms.
Identify whether the log transformation was successful in producing a more symmetric distribution or not.
b.
Answer to Problem 107E
The histogram by transforming the data using logarithms is given below:
Yes, the log transformation was successful in producing a more symmetric distribution.
Explanation of Solution
Calculation:
It is given that the body mass of the 50 different bird species. The log for the data values is obtained as shown below:
Body Mass | Log (Body Mass) | Transformed values |
7.7 | log (7.7) | 0.88649 |
10.1 | log (10.1) | 1.00432 |
21.6 | log (21.6) | 1.33445 |
8.6 | log (8.6) | 0.93450 |
12 | log (12) | 1.07918 |
11.4 | log (11.4) | 1.05690 |
16.6 | log (16.6) | 1.22011 |
9.4 | log (9.4) | 0.97313 |
11.5 | log (11.5) | 1.06070 |
9 | log (9) | 0.95424 |
8.2 | log (8.2) | 0.91381 |
20.2 | log (20.2) | 1.30535 |
48.5 | log (48.5) | 1.68574 |
21.6 | log (21.6) | 1.33445 |
26.1 | log (26.1) | 1.41664 |
6.2 | log (6.2) | 0.79239 |
19.1 | log (19.1) | 1.28103 |
21 | log (21) | 1.32222 |
28.1 | log (28.1) | 1.44871 |
10.6 | log (10.6) | 1.02531 |
31.6 | log (31.6) | 1.49969 |
6.7 | log (6.7) | 0.82607 |
5 | log (5) | 0.69897 |
68.8 | log (68.8) | 1.83759 |
23.9 | log (23.9) | 1.37840 |
19.8 | log (19.8) | 1.29667 |
20.1 | log (20.1) | 1.30320 |
6 | log (6) | 0.77815 |
99.6 | log (99.6) | 1.99826 |
19.8 | log (19.8) | 1.29667 |
16.5 | log (16.5) | 1.21748 |
9 | log (9) | 0.95424 |
448 | log (448) | 2.65128 |
21.3 | log (21.3) | 1.32838 |
17.4 | log (17.4) | 1.24055 |
36.9 | log (36.9) | 1.56703 |
34 | log (34) | 1.53148 |
41 | log (41) | 1.61278 |
15.9 | log (15.9) | 1.20140 |
12.5 | log (12.5) | 1.09691 |
10.2 | log (10.2) | 1.00860 |
31 | log (31) | 1.49136 |
21.5 | log (21.5) | 1.33244 |
11.9 | log (11.9) | 1.07555 |
32.5 | log (32.5) | 1.51188 |
9.8 | log (9.8) | 0.99123 |
93.9 | log (93.9) | 0.97267 |
10.9 | log (10.9) | 1.03743 |
19.6 | log (19.6) | 1.29226 |
14.5 | log (14.5) | 1.16137 |
Software procedure:
Step-by-step procedure to obtain histogram using MINITAB:
- Choose Graph > Histogram.
- Choose Simple, and then click OK.
- In Graph variables, enter the corresponding column of Logarithm of Body mass.
- Click OK.
- On graph right click on X axis, select edit X scale.
- Select Binning.
- Under Interval Type, Choose cut point.
- Click OK.
Justification: It can be observed that the histogram of the transformed data (using logarithms) is more near to symmetrical shape when compared to the untransformed data. This shows that using the transformation of logarithms produce a more symmetrical distribution for body mass.
Hence, the log transformation was successful in producing a more symmetric distribution.
c.
Construct the histogram by transforming the data using
Identify whether the transformation
c.
Answer to Problem 107E
The histogram by transforming the data using
Yes, the transformation
Explanation of Solution
Calculation:
The transformation for the data values using
Body Mass | Transformed values | |
7.7 | 0.360375 | |
10.1 | 0.314658 | |
21.6 | 0.215166 | |
8.6 | 0.340997 | |
12 | 0.288675 | |
11.4 | 0.296174 | |
16.6 | 0.245440 | |
9.4 | 0.326164 | |
11.5 | 0.294884 | |
9 | 0.333333 | |
8.2 | 0.349215 | |
20.2 | 0.222497 | |
48.5 | 0.143592 | |
21.6 | 0.215166 | |
26.1 | 0.195740 | |
6.2 | 0.401610 | |
19.1 | 0.228814 | |
21 | 0.218218 | |
28.1 | 0.188646 | |
10.6 | 0.307148 | |
31.6 | 0.177892 | |
6.7 | 0.386334 | |
5 | 0.447214 | |
68.8 | 0.120561 | |
23.9 | 0.204551 | |
19.8 | 0.224733 | |
20.1 | 0.223050 | |
6 | 0.408248 | |
99.6 | 0.100201 | |
19.8 | 0.224733 | |
16.5 | 0.246183 | |
9 | 0.333333 | |
448 | 0.017546 | |
21.3 | 0.216676 | |
17.4 | 0.239732 | |
36.9 | 0.164622 | |
34 | 0.171499 | |
41 | 0.156174 | |
15.9 | 0.250785 | |
12.5 | 0.282843 | |
10.2 | 0.313112 | |
31 | 0.179605 | |
21.5 | 0.215666 | |
11.9 | 0.289886 | |
32.5 | 0.175412 | |
9.8 | 0.319438 | |
93.9 | 0.103197 | |
10.9 | 0.302891 | |
19.6 | 0.225877 | |
14.5 | 0.262613 |
Software procedure:
Step-by-step procedure to obtain histogram using MINITAB:
- Choose Graph > Histogram.
- Choose Simple, and then click OK.
- In Graph variables, enter the corresponding column of 1/sqrt(Body mass).
- Click OK.
- On graph right click on X axis, select edit X scale.
- Select Binning.
- Under Interval Type, Choose cut point.
- Click OK.
Justification: It can be observed that the histogram of the transformed data (using
Hence, the transformation
Want to see more full solutions like this?
Chapter 7 Solutions
Introduction To Statistics And Data Analysis
- Percent 13 A car dealer specializing in minivan sales saibe conducts a survey to find out more about who its customers are. One of the variables at the company measures is gender; the results of this part of the survey are shown in the following bar graph. pow a. Interpret these results. b. Explain whether you think the bar graph is a fair and accurate representation of this data. 70 Gender of Customers 60 50 40 30 20 10 0 Males Femalesarrow_forwardThree cat- ency bar 10 Suppose that a health club asks 30 customers ad to rate the services as very good (1), good (2), fair (3), or poor (4). You can see the results in the following bar graph. What percentage of the customers rated the services as good? n; 2: pinion). of this to make a eople in ng ban?) Health Club Customer Ratings (1-very good,..., 4-poor) Frequency 10 8 00 6 11 A polling orga what voters t random samp for their opin no opinion. following ba a. Make a (includ bob. Evalua fairly tral 2 0 1 -2 3 4 540 480 420 360 300 240 Frequencyarrow_forward1 - Multiple Regression Equations and Predictions with XLMiner Analysis ToolPak (Structured) Video The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak X Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). JAN 27 Revenue = × TVAdv + b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = + TVAdy + NewsAdv c. Is the estimated regression equation coefficient for…arrow_forward
- Question 2: When John started his first job, his first end-of-year salary was $82,500. In the following years, he received salary raises as shown in the following table. Fill the Table: Fill the following table showing his end-of-year salary for each year. I have already provided the end-of-year salaries for the first three years. Calculate the end-of-year salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as the one in the following table, your formula / approach is incorrect) (2 points) Geometric Mean of Salary Raises: Calculate the geometric mean of the salary raises using the percentage figures provided in the second column named “% Raise”. (The geometric mean for this calculation should be nearly identical to the arithmetic mean. If your answer deviates significantly from the mean, it's likely incorrect. 2 points) Hint for the first part of question 2: To assist you with filling out the table in the first part of the question,…arrow_forwardConsider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Compute the range, interquartile range, variance, and standard deviation (to a maximum of 2 decimals, if decimals are necessary). Range Interquartile range Variance Standard deviationarrow_forwardPerform a Step by step following tests in Microsoft Excel. Each of the following is 0.5 points, with a total of 6 points. Provide your answers in the following table. Median Standard Deviation Minimum Maximum Range 1st Quartile 2nd Quartile 3rd Quartile Skewness; provide a one sentence explanation of what does the skewness value indicates Kurtosis; provide a one sentence explanation of what does the kurtosis value indicates Make a labelled histogram; no point awarded if it is not labelled Make a labelled boxplot; no point awarded if it is not labelled Data 27 30 22 25 24 22 20 28 20 26 21 23 24 20 28 30 20 28 29 30 21 26 29 25 26 25 20 30 26 28 25 21 22 27 27 24 26 22 29 28 30 22 22 22 30 21 21 30 26 20arrow_forward
- Obtain the linear equation for trend for time series with St² = 140, Ey = 16.91 and Σty= 62.02, m n = 7arrow_forwardA quality characteristic of a product is normally distributed with mean μ and standard deviation σ = 1. Speci- fications on the characteristic are 6≤x≤8. A unit that falls within specifications on this quality characteristic results in a profit of Co. However, if x 8, the profit is -C2. Find the value ofμ that maximizes the expected profit.arrow_forwardA) The output voltage of a power supply is normally distributed with mean 5 V and standard deviation 0.02 V. If the lower and upper specifications for voltage are 4.95 V and 5.05 V, respectively, what is the probability that a power supply selected at random conform to the specifications on voltage? B) Continuation of A. Reconsider the power supply manufacturing process in A. Suppose We wanted to improve the process. Can shifting the mean reduce the number of nonconforming units produced? How much would the process variability need to be reduced in order to have all but one out of 1000 units conform to the specifications?arrow_forward
- der to complete the Case X T Civil Service Numerical Test Sec X T Casework Skills Practice Test Maseline Vaseline x + euauthoring.panpowered.com/DeliveryWeb/Civil Service Main/84589a48-6934-4b6e-a6e1-a5d75f559df9?transferToken-News NGSSON The table below shows the best price available for various items from 4 uniform suppliers. The prices do not include VAT (charged at 20%). Item Waterproof boots A1-Uniforms (£)Best Trade (£)Clothing Tech (£)Dress Right (£) 59.99 39.99 59.99 49.99 Trousers 9.89 9.98 9.99 11.99 Shirts 14.99 15.99 16.99 12.99 Hi-Vis vest 4.49 4.50 4.00 4.00 20.00 25.00 19.50 19.99 Hard hats A company needs to buy a set of 12 uniforms which includes 1 of each item. If the special offers are included which supplier is cheapest? OOO A1-Uniforms Best Trade Clothing Tech Q Search + ** 109 8 CO* F10 Home F11 F12 6arrow_forwardto complete the Case × T Civil Service Numerical Test Sec x T Casework Skills Practice Test + Vaseline euauthoring.panpowered.com/DeliveryWeb/Civil Service Main/84589a48-b934-4b6e-a6e1-a5d75f559df9?transferToken=MxNewOS NGFSPSZSMOMzuz The table below shows the best price available for various items from 4 uniform suppliers. The prices do not include VAT (charged at 20%). Item A1-Uniforms (£)Best Trade (£)Clothing Tech (£)Dress Right (£) Waterproof boots 59.99 39.99 59.99 49.99 Trousers 9.89 9.98 9.99 11.99 Shirts 14.99 15.99 16.99 12.99 Hi-Vis vest 4.49 4.50 4.00 4.00 20.00 25.00 19.50 19.99 Hard hats A company needs to buy a set of 12 uniforms which includes 1 of each item. If the special offers are included, which supplier is cheapest? O O O O A1-Uniforms Best Trade Clothing Tech Dress Right Q Search ENG L UK +0 F6 四吧 6 78 ㄓ F10 9% * CO 1 F12 34 Oarrow_forwardCritics review films out of 5 based on three attributes: the story, the special effects and the acting. The ratings of four critics for a film are collected in the table below.CriticSpecialStory rating Effects rating Acting rating Critic 14.44.34.5Critic 24.14.23.9Critic 33.943.4Critic 44.24.14.2Critic 1 also gave the film a rating for the Director's ability. If the average of Critic 1's ratings was 4.3 what rating did they give to the Director's ability?3.94.04.14.24.3arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL