16. A process engineer at Sival Electronics was trying to determine whether three suppliers would be equally capable of supplying the mounting boards for the new “gold plated” components that she was testing. The Ch05Data.xlsx file for Prob05-16 on the Student Companion Site shows the coded defect levels for the suppliers, according to the finishes that were tested. Lower defect levels are preferable to larger levels. Using one-way ANOVA, analyze these results. What conclusion can be reached, based on these data?

14. Softswift, a software developer, is trying to determine if any of three potential subcontractors has better programmers in order to outsource a development project. The three subcontractors agreed to test five pro-grammers, using a standardized test provided by Softswift, as provided in the data in the Ch05Data.xlsx Excel workbook file for Prob05-14. Use the single factor ANOVA Excel tool to determine if there is a significant dif-ference between the scores of programmers at the three contractors at the 5 percent level.

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN

5) The letter grades on the midterm exam given in a large managerial statistics class are normally distributed with mean 75 and standard deviation 9. The instructor of this class wants to assign an A grade to the top 10% of the scores, a B grade to the next 10% of the scores, a C grade to the next 10% of the scores, a D grade to the next 10% of the scores and an F grade to all scores below the 60th percentile of this distribution. For each possible letter grade, find the lowest acceptable score.

A manufacturer of TV sets claims that at least 98% of its TV sets can last more than 10 years without needing a single repair. In order to verify and challenge this claim, a consumer group randomly selected 800 consumers who had owned a TV set made by this manufacturer for 10 years. Of these 800 consumers, 60 said that their TV sets needed some repair at least once. a. Is there significant evidence showing that the manufacturer’s claim is false? Test using α = 0.01. b. Do the data support that the manufacturer’s actual no-repair rate does not even reach 94%? Use α = 0.01. need to know how the variance is found step by step

c. Explain the concept of ANOVA, and say how you can conduct an ANOVA analysis for the wages/salaries of three categories of workers in your firm. Use an example to illustrate. Clearly indicate the F-Statistic and the Critical Value and their meanings

1. Determine the following probabilities and for each item, provide a sketch of the associated areas (3 points each).

a. P(z > 1.69)

b. P(z < -2.03)

c. P(z > -0.50)

d. P(-0.39 < z < 0)

e. P(0.75 < z < 2.01)

You may need to use the appropriate technology to answer this question.

Consider the following data for a dependent variable y and two independent variables,

x₁

and

x₂.

The estimated regression equation for these data is

ŷ = −18.21 + 2.01x₁ + 4.72x₂.

Here, SST = 15,134.9, SSR = 13,994.6,

s_b1 = 0.2482,

and

s_b2 = 0.9524.

(a)

Test for a significant relationship among

x₁, x₂, and y.

Use α = 0.05.

State the null and alternative hypotheses.

H₀: β₁ > β₂
H_a: β₁ ≤ β₂H₀: β₁ = β₂ = 0
H_a: One or more of the parameters is not equal to zero.     H₀: β₁ ≠ 0 and β₂ ≠ 0
H_a: One or more of the parameters is equal to zero.H₀: β₁ ≠ 0 and β₂ = 0
H_a: β₁ = 0 and β₂ ≠ 0H₀: β₁ < β₂
H_a: β₁ ≥ β₂

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H₀. There is sufficient evidence to conclude that there is a significant relationship among the variables.Do not reject H₀. There is insufficient evidence to conclude that there is a significant relationship among the variables.     Do not reject H₀. There is sufficient evidence to conclude that there is a significant relationship among the variables.Reject H₀. There is insufficient evidence to conclude that there is a significant relationship among the variables.

(b)

Is

β₁

significant? Use α = 0.05.

State the null and alternative hypotheses.

H₀: β₁ = 0
H_a: β₁ ≠ 0H₀: β₁ < 0
H_a: β₁ ≥ 0     H₀: β₁ > 0
H_a: β₁ ≤ 0H₀: β₁ = 0
H_a: β₁ > 0H₀: β₁ ≠ 0
H_a: β₁ = 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H₀. There is sufficient evidence to conclude that β₁ is significant.Reject H₀. There is insufficient evidence to conclude that β₁ is significant.     Do not reject H₀. There is sufficient evidence to conclude that β₁ is significant.Do not reject H₀. There is insufficient evidence to conclude that β₁ is significant.

(c)

Is

β₂

significant? Use α = 0.05.

State the null and alternative hypotheses.

H₀: β₂ < 0
H_a: β₂ ≥ 0H₀: β₂ > 0
H_a: β₂ ≤ 0     H₀: β₂ ≠ 0
H_a: β₂ = 0H₀: β₂ = 0
H_a: β₂ ≠ 0H₀: β₂ = 0
H_a: β₂ > 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H₀. There is sufficient evidence to conclude that β₂ is significant.Do not reject H₀. There is sufficient evidence to conclude that β₂ is significant.     Do not reject H₀. There is insufficient evidence to conclude that β₂ is significant.Reject H₀. There is insufficient evidence to conclude that β₂ is significant.

The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals who are in marketing. Three groups are considered: management, research and advertising (higher scores indicate higher ethical values).

1. Compute the values identified below (to 1 decimal, if necessary).
   

   Sum of Squares, Treatment
   Sum of Squares, Error
   Mean Squares, Treatment
   Mean Squares, Error

   
   
2. Use  = .05 to test for a significant difference in perception among the three groups.
   
   Calculate the value of the test statistic (to 2 decimals).
     
   
   The p-value is Selectless than .01between .01 and .025between .025 and .05between .05 and .10greater than .10Item 6  
   
   What is your conclusion?
   SelectConclude the mean perception scores for the three groups are not all the sameCannot conclude there are differences among the mean perception scores for the three groupsItem 7  
   
3. Using  = .05, determine where differences between the mean perception scores occur.
   
   Calculate Fisher's LSD value (to 2 decimals).
     
   
   Test whether there is a significant difference between the means for marketing managers (1), marketing research specialists (2), and advertising specialists (3).
   

   Difference	Absolute Value	Conclusion
   1 -  2		SelectSignificant differenceNo significant differenceItem 10
   1 -  3		SelectSignificant differenceNo significant differenceItem 12
   2 -  3		SelectSignificant differenceNo significant differenceItem 14

Smoking during pregnancy can cause a baby to be born too early or to have low birth weight. Design a study that would test this statement.? Describe the problem? What is the sample size? Variable should be define? Parametric or nonparametric? Make the conclusion?

Use technology and the given confidence level and sample data to find the confidence interval for the population mean mu μ. Assume that the population does not exhibit a normal distribution. Weight lost on a diet:

90% confidence n=41 x x=3.0 kg s=5.6 kg

What is the confidence interval for the population mean mu μ​? _<μ<_

Creating a Digital Survey

Create the shareable link for your survey and paste it in as the submission for this assignment.

Collect the following information:

Age

Gender

Birth Month

Height (in Inches)

Shoe Size

Eye Color

Number of hours of TV (movies, streaming, etc.) watched last night

Number of credits currently taking

Number of hours of sleep gotten last night

Number of hours worked last week

Number of songs on digital music player

Number of friends on Facebook

Number of times per day check social media sites

Number of tattoos

Number of siblings

Time usually go to bed

Level of Math anxiety (none, low, medium, high)

Cell phone carrier

Incorporate the following additional requirements onto your survey:

An answer field of each of the following types: Short Answer, Multiple Choice, Dropdown, Time

Add response validation to at least one of your Short Answer fields

Add at least one section break

You may need to use the appropriate appendix table or technology to answer this question.

According to the National Association of Colleges and Employers, the 2015 mean starting salary for new college graduates in health sciences was $51,541. The mean 2015 starting salary for new college graduates in business was $53,901. † Assume that starting salaries are normally distributed and that the standard deviation for starting salaries for new college graduates in health sciences is $11,000. Assume that the standard deviation for starting salaries for new college graduates in business is $17,000.

(a)

What is the probability that a new college graduate in business will earn a starting salary of at least $65,000? (Round your answer to four decimal places.)

(b)

What is the probability that a new college graduate in health sciences will earn a starting salary of at least $65,000? (Round your answer to four decimal places.)

(c)

What is the probability that a new college graduate in health sciences will earn a starting salary less than $46,000? (Round your answer to four decimal places.)

(d)

How much would a new college graduate in business have to earn in dollars in order to have a starting salary higher than 99% of all starting salaries of new college graduates in the health sciences? (Round your answer to the nearest whole number.)

$

The accompanying data represent the miles per gallon of a random sample of cars with a​ three-cylinder, 1.0 liter engine. ​(a) Compute the​ z-score corresponding to the individual who obtained 32.7 miles per gallon. Interpret this result. ​(b) Determine the quartiles. ​(c) Compute and interpret the interquartile​ range, IQR. ​(d) Determine the lower and upper fences. Are there any​ outliers?

1. Forecast the price index for Q3 2018 using a​ two-period simple moving average.

(Round to two decimal places)

2. Calculate the MAD for the forecast in part a

(Round to two decimal places)

3. Forecast the price index for Q3 2017 using a​ three-period simple moving average.

(Round to two decimal places)

4. Calculate the MAD for the forecast in part c.

(Round to two decimal places)

The 58th annual convention of the American Legion was held in Philadelphia from July 21 until July 24, 1976. People at the convention included American Legion delegates, their families, and other Legionnaires who were not official delegates. Between July 20 and August 30, some of those who had been present became ill with a type of pneumonia that was subsequently named Legionnaires' disease. No one attending the convention developed the disease after August 30th. The number of delegates who developed Legionnaires' disease during the period of July 20 to August 30 are as follows:

Developed Legionnaires' Disease

Determine if the null hypothesis is true:There is no association between Delegates and Legionnaires' Disease.