for question 28) EXCEL ONLY!! please take screenshot of answers within excel. please so not attempt to answer if not submitted through excel! thank you
question 1 doesnt have to be through excel. just need answers only. thanks!
FILE Dearborn, Michigan. The director of purchasing asked for samples of 100 from each manufacturer. The numbers of acceptable and unacceptable bulbs from each manufacturer are shown below. At the.05 significance level, is there a difference in the quality of the bulbs? Four brands of lightbulbs are being considered for use in the final assembly area of the Ford F-150 truck plant in 28. Manufacturer Unacceptable 12 8 92 100 5 95 100 89 Acceptable Total 100 100 Chapter 15- Assignment (Lab) i Saved Help Save & Ex A sample of employees at a large chemical plant was asked to indicate a preference for one of three pension plans. The results are given in the following table. Does it seem that there is a relationship between the pension plan selected and the job classification of the employees? Use the 0.05 significance level Pension Plarn Plan B Job Class Plan A Supervisor Clerical Labor Plan C 42 33.33 points 41 40 47 61 59 30 Spicture Cli State the decision rule. Use 0.05 significance level. (Round your answer to 3 decimal places.) Hg: Pension plan preference and job class are not related References H1: Pension plan preference and job class are related Reject HO if chi Compute the value of chi-square. (Round your answer to 3 decimal places.) Compute the value of chi-square. (Round your answer to 3 decimal places.) Chi-square What is your decision regarding Ho? HO. There is relationship between pension plan preference and job class FILE Dearborn, Michigan. The director of purchasing asked for samples of 100 from each manufacturer. The numbers of acceptable and unacceptable bulbs from each manufacturer are shown below. At the.05 significance level, is there a difference in the quality of the bulbs? Four brands of lightbulbs are being considered for use in the final assembly area of the Ford F-150 truck plant in 28. Manufacturer Unacceptable 12 8 92 100 5 95 100 89 Acceptable Total 100 100 Chapter 15- Assignment (Lab) i Saved Help Save & Ex A sample of employees at a large chemical plant was asked to indicate a preference for one of three pension plans. The results are given in the following table. Does it seem that there is a relationship between the pension plan selected and the job classification of the employees? Use the 0.05 significance level Pension Plarn Plan B Job Class Plan A Supervisor Clerical Labor Plan C 42 33.33 points 41 40 47 61 59 30 Spicture Cli State the decision rule. Use 0.05 significance level. (Round your answer to 3 decimal places.) Hg: Pension plan preference and job class are not related References H1: Pension plan preference and job class are related Reject HO if chi Compute the value of chi-square. (Round your answer to 3 decimal places.) Compute the value of chi-square. (Round your answer to 3 decimal places.) Chi-square What is your decision regarding Ho? HO. There is relationship between pension plan preference and job class
