excel

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

Normal Population Hypothesis Test

A sample of 33 observations is selected from a normal population. The sample mean is 30, and the  population standard deviation is 3. Conduct the following test of hypothesis using the 0.05 significance  level. H0 : μ<= 29 H1 : μ > 29 Setting up a Hypothesis Test in Excel [...]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

Tomato Farmer Two Population Means – Spreadsheet Solutions

The spreadsheet below shows the hypothesis tests performed for the two population means of the tomato farmer. Tomato Farmer Two Population Means SpreadsheetRead more