# qnt 351

### Hypothesis Test μ ≤ 10 – Solve Test Statistic

Given the following hypotheses: H0 : μ ≤ 10 H1 : μ > 10 A random sample of 10 observations is selected from a normal population. The sample mean was 12 and the sample standard deviation 3. Using the .05 significance level: Look closely at the formulas in the excel spreadsheet [...]Read more

### Hypothesis Test μ = 400 – Solve Test Statistic

Given the following hypotheses: H0 : μ = 400 H1 : μ ≠ 400 A random sample of 12 observations is selected from a normal population. The sample mean was 407 and the sample standard deviation 6. Using the .01 significance level: Setup the problem in excel and solve for the test [...]Read more

### Hypothesis Test United Nations Report – Solution Guide

A United Nations report shows the mean family income for Mexican migrants to the United States is \$26,700 per year. A FLOC (Farm Labor Organizing Committee) evaluation of 21 Mexican family units reveals a mean to be \$28,450 with a sample standard deviation of \$10,850. Does this [...]Read more

### Hypothesis Test Rocky Mountain Rath Publishing – Solution Guide

The Rocky Mountain district sales manager of Rath Publishing Inc., a college textbook publishing company, claims that the sales representatives make an average of 36 sales calls per week on professors. Several reps say that this estimate is too low. To investigate, a random [...]Read more

### Hypothesis Test H0 : μ ≥ 220 – Solve Test Statistic and p-Value

The following information is available. H0 : μ ≥ 220 H1 : μ < 220 A sample of 64 observations is selected from a normal population. The sample mean is 215, and the population standard deviation is 15. Conduct the following test of hypothesis using the .025 significance level. [...]Read more

### Grumney Family Restaurant Ms. Brigden Tips – Solution Guide

At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, “You can average \$70 a day in tips.” Assume the population of daily tips is normally distributed with a standard deviation of \$3.46. Over the first 32 days she was employed at the [...]Read more

### Probability Sample Vs. Nonprobability Sample

Describe the differences between a probability sample and a nonprobability sample A probability sample collects and aggregates data is a way that is completely unbiased and not affected by subjective assumptions of the researchers. A true probability sample of American adults [...]Read more

### Pennsylvania Refining Company – Is the correlation in the population greater than zero?

Problem Overview In this tutorial, we are going to find out if the correlation in a sample population greater than zero using Excel.  Pennsylvania Refining Company is studying the relationship between the pump price of gasoline and the number of gallons sold. For a sample of 20 [...]Read more

### Maumee Ford-Mercury- Volvo Coefficient of Determination Solution

Problem Details The problem we are tackling in this tutorial is about car dealership data. We will show you how the find the Coefficient of Determination using Excel. The owner of Maumee Ford-Mercury- Volvo wants to study the relationship between the age of a car and its selling [...]Read more

### Bi-lo Appliance Super-Store Correlation Coefficient Solution

The famous Bi-Lo regression question goes something like this: Bi-lo Appliance Super-Store has outlets in several large metropolitan areas in New England. The general sales manager aired a commercial for a digital camera on selected local TV stations prior to a sale starting on [...]Read more