
a.
Obtain the null and the alternative hypotheses.
a.

Explanation of Solution
The null and alternative hypotheses are given below:
Null Hypothesis
That is, the
Alternative Hypothesis
b.
Give the decision rule.
b.

Explanation of Solution
The treatment and error degrees of freedom are given below:
Treatment degrees of freedom:
Error degrees of freedom:
Here, the level of significance
Step-by-step procedure to obtain the critical F value using Excel-MegaStat:
- In EXCEL, Select Add-Ins > MegaStat > Probability.
- Choose probability> F-distribution> calculate F given probability.
- Enter P as 0.05.
- Enter df1 as 2.
- Enter df2 as 9.
- Click Ok.
Output using the Excel-MegaStat software is given below:
From the output, the critical F value is 4.26.
Decision rule:
If
Therefore, the decision rule is to reject
c.
Find the values of SST, SSE and SS total.
c.

Answer to Problem 11E
The value of SST is 107.20.
The value of SSE is 9.47.
The value of SS total is 116.67.
Explanation of Solution
Here, the level of significance
Step-by-step procedure to obtain the sum of square total, sum of square treatment and sum of square error using Excel-MegaStat:
- Choose MegStat > Analysis of Variance > One-Factor ANOVA.
- Select the column of Treatment 1, Treatment 2 and Treatment 3 in Input
range . - Click OK.
Output using the Excel-MegaStat software is given below:
From the output, the values of SST is 107.20, SSE is 9.47 and SS total is 116.67.
d.
Find an ANOVA table.
d.

Explanation of Solution
From the output in Part (c), the ANOVA table is obtained.
The ANOVA table is given below:
Source of Variation | Sum of Squares | Degrees of Freedom | Mean Square | F |
Treatments | 107.2 | 2 | 53.6 | 50.96 |
Error | 9.47 | 9 | 1.05 | |
Total | 116.67 | 11 |
e.
Find the decision regarding the null hypothesis.
e.

Explanation of Solution
Conclusion:
The F value is 50.96 and the F critical value is 4.26.
Here, F value is greater than F critical value. That is, 50.96 > 4.26.
Using rejection rule, reject the null hypothesis.
Therefore, there is sufficient evidence that at least one mean of all treatment is differ from others.
f.
Check whether there is significant difference between treatment 1 and treatment 2, if null hypothesis is rejected by using the 95% level of confidence.
f.

Explanation of Solution
A 95% confidence interval is as follows:
Where,
From the output in Part (c), the mean of treatment 1 is 9.7, mean of treatment 2 is 2.2, and MSE is 1.052.
Step-by-step procedure to obtain t-critical value using Excel-MegaStat:
- In EXCEL, Select Add-Ins > MegaStat > Probability > t-Distribution.
- Select calculate t given P.
- Enter probability as 0.05.
- Enter df as 9.
- Under Shading, choose two-tail.
- Click Ok.
Output using the Excel-MegaStat software is given below:
From the output, the t is
Therefore, a 95% confidence interval for that difference is 5.8 and 9.2. Here, 0 does not include in the confidence interval.
It means that there is a significant difference between the means of treatment 1 and treatment 2 because the endpoints have same sign or does not include zero.
Want to see more full solutions like this?
Chapter 12 Solutions
Gen Combo Ll Statistical Techniques In Business And Economics; Connect Ac
- A test consists of 10 questions made of 5 answers with only one correct answer. To pass the test, a student must answer at least 8 questions correctly. (a) If a student guesses on each question, what is the probability that the student passes the test? (b) Find the mean and standard deviation of the number of correct answers. (c) Is it unusual for a student to pass the test by guessing? Explain.arrow_forwardIn a group of 40 people, 35% have never been abroad. Two people are selected at random without replacement and are asked about their past travel experience. a. Is this a binomial experiment? Why or why not? What is the probability that in a random sample of 2, no one has been abroad? b. What is the probability that in a random sample of 2, at least one has been abroad?arrow_forwardQuestions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.arrow_forward
- To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13-inch models (Consumer Reports website, October 25, 2012). Brand & Model Price ($) Overall Score Samsung Ultrabook NP900X3C-A01US 1250 83 Apple MacBook Air MC965LL/A 1300 83 Apple MacBook Air MD231LL/A 1200 82 HP ENVY 13-2050nr Spectre XT 950 79 Sony VAIO SVS13112FXB 800 77 Acer Aspire S5-391-9880 Ultrabook 1200 74 Apple MacBook Pro MD101LL/A 1200 74 Apple MacBook Pro MD313LL/A 1000 73 Dell Inspiron I13Z-6591SLV 700 67 Samsung NP535U3C-A01US 600 63 a. Select a scatter diagram with price as the independent variable. b. What does the scatter diagram developed in part (a) indicate about the relationship…arrow_forwardTo the Internal Revenue Service, the reasonableness of total itemized deductions depends on the taxpayer’s adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for a given level of income, the chances of an IRS audit are increased. Data (in thousands of dollars) on adjusted gross income and the average or reasonable amount of itemized deductions follow. Adjusted Gross Income ($1000s) Reasonable Amount ofItemized Deductions ($1000s) 22 9.6 27 9.6 32 10.1 48 11.1 65 13.5 85 17.7 120 25.5 Compute b1 and b0 (to 4 decimals).b1 b0 Complete the estimated regression equation (to 2 decimals). = + x Predict a reasonable level of total itemized deductions for a taxpayer with an adjusted gross income of $52.5 thousand (to 2 decimals). thousand dollarsWhat is the value, in dollars, of…arrow_forwardK The mean height of women in a country (ages 20-29) is 63.7 inches. A random sample of 65 women in this age group is selected. What is the probability that the mean height for the sample is greater than 64 inches? Assume σ = 2.68. The probability that the mean height for the sample is greater than 64 inches is (Round to four decimal places as needed.)arrow_forward
- In a survey of a group of men, the heights in the 20-29 age group were normally distributed, with a mean of 69.6 inches and a standard deviation of 4.0 inches. A study participant is randomly selected. Complete parts (a) through (d) below. (a) Find the probability that a study participant has a height that is less than 68 inches. The probability that the study participant selected at random is less than 68 inches tall is 0.4. (Round to four decimal places as needed.) 20 2arrow_forwardPEER REPLY 1: Choose a classmate's Main Post and review their decision making process. 1. Choose a risk level for each of the states of nature (assign a probability value to each). 2. Explain why each risk level is chosen. 3. Which alternative do you believe would be the best based on the maximum EMV? 4. Do you feel determining the expected value with perfect information (EVWPI) is worthwhile in this situation? Why or why not?arrow_forwardQuestions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.arrow_forward
- You are provided with data that includes all 50 states of the United States. Your task is to draw a sample of: o 20 States using Random Sampling (2 points: 1 for random number generation; 1 for random sample) o 10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1 for random sample different from the previous answer; 1 for correct K value calculation table; 1 for correct sample drawn by using systematic sampling) (For systematic sampling, do not use the original data directly. Instead, first randomize the data, and then use the randomized dataset to draw your sample. Furthermore, do not use the random list previously generated, instead, generate a new random sample for this part. For more details, please see the snapshot provided at the end.) Upload a Microsoft Excel file with two separate sheets. One sheet provides random sampling while the other provides systematic sampling. Excel snapshots that can help you in organizing columns are provided on the next…arrow_forwardThe population mean and standard deviation are given below. Find the required probability and determine whether the given sample mean would be considered unusual. For a sample of n = 65, find the probability of a sample mean being greater than 225 if μ = 224 and σ = 3.5. For a sample of n = 65, the probability of a sample mean being greater than 225 if μ=224 and σ = 3.5 is 0.0102 (Round to four decimal places as needed.)arrow_forward***Please do not just simply copy and paste the other solution for this problem posted on bartleby as that solution does not have all of the parts completed for this problem. Please answer this I will leave a like on the problem. The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharingarrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning


