Question

In: Statistics and Probability

Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do...

Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do NOT use Excel built-in functions or solvers (except t.inv() and f.inv() to obtain critical t and f values).

The tensile strength of Portland cement is being studied. Four different mixing techniques can be used economically. A completely randomized experiment was conducted and the following data were collected:

Technique Tensile Strength Tensile Strength Tensile Strength Tensile Strength
1 3129 3000 2865 2890
2 3200 3300 2975 3150
3 2800 290 2985 3050
4 2600 2700 2600 2765

a) Test the hypothesis that mixing techniques affect the strength of the cement (α = 0.05).

b) Use the Fisher LSD method with α = 0.05 to make comparisons between pairs of means.

c) Repeat part (b) using Tukey’s test. Do you get the same conclusions as part (b)? If not, explain why.

d) Find a 95 percent confidence interval on the mean tensile strength of the Portland cement produced by each of the four mixing techniques. Also find a 95 percent confidence interval on the difference in means for techniques a and c.

e) Construct a normal probability plot of the residuals and a plot of residuals vs. predicted values (using Minitab). What conclusion would you draw from each plot?

f) Suppose Technique d is the current mixing technique. We would like to compare it with the average effect of the new techniques (Techniques a, b and c). Also, we are interested in whether Technique b is significantly different from the average effect of the two other new techniques (Techniques a and c). Construct the required contrasts to test these and apply Scheffe’s method to make conclusions. Set α = 0.05

Solutions

Expert Solution

Hypothesis:

H0: The mean strength of the cement is the same for 4 types of technique.
H1: The mean strength of the cement is not the same for 4 types of technique.

Let a represent the mixing strength of technique 1

=(3129   3000   2865   2890)
Let b represent the mixing strength of technique 2

= (3200   3300   2975   3150)
Let c represent the mixing strength of technique 3

= (2800   2900   2985   3050)

Let c represent the mixing strength of technique 4

= (2600   2700   2600   2765)
(g represents grand total)
We find the mean of both groups and the entire data

No of observation in each group

no. of groups = k = 4

Next we find the difference between each observation in the group with mean of the group and square it up.
example In group A we take the first observation and minus it the group mean ,this is done for each observation and for every group and summed up

Sum of square within the groups

Mean sum of square within the groups
MSW = rac{SSW}{ (n_g-k)}= 163246.72

Sum of square between the groups

Mean sum of square between the groups

Using the F table we find pvalue with df1 = 3 and df2=12
pvalue = 0.0004887

Table summarizing the output

Since the pvalue is less than 0.05, we reject the null hypothesis and conclude that the mean strength of the cement is not same for 4 types of technique

Please like the answer


Related Solutions

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. 1. A $1,000 par value 8-year bond with a 13 percent coupon rate recently sold...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. 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 follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 101 3.0 2.5 a. Develop an estimated...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (x1) and newspaper advertising (x2). Values of y, x1, and x2 are expressed in thousands of dollars. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 96 5 1.5 90 2 2    95 4 1.5 92    2.5 2.5 95 3 3.3 94    3.5 2.3...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. 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 follow. Use computer software packages, such as Minitab or Excel, to solve this problem. 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...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (iii) Calculate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT