# Statistics

### Statistical Communication for Rating, Ranking, Sorting Data

Choosing an Effective Communication Method for Statistical Studies The decision of an optimal communication method occurs when a researcher has determined the best data collection approach. In the current business environment, technology has produced extensive changes to 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

### Solve the Regression Equation for Random Observations

In this tutorial, we will use a series for random observations to perform a simple linear regression. The following sample observations were randomly selected. X 4 5 3 6 10 Y 9.8 12.6 9 14.4 19.6 Part A – The Regression Equation Regression Equation: Y = a + bX We can solve [...]Read more

### Celltronics Correlation Coefficient Solution

Correlation Coefficient The correlation coefficient quantifies the relationship between two or more random variables. It can be calculated in MS Excel using the CORREL function, which we demonstrate below. The production department of Celltronics International wants to explore [...]Read more

### Tomato Farmer Two Population Means – Solution and Explanation

Two Population Means Answer Guide A tomato farmer with a very large farm of approximately 2200 acres had heard about a new type of rather expensive fertilizer which would supposedly significantly increase his production. The frugal farmer wanted to test the new fertilizer before [...]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

### Statistics Guide: A study of long-distance phone calls made from General Electric Corporate Headquarters

In this tutorial, we provide an image of the formatting in an excel spreadsheet. For each problem we show the actual formula to plug into the cell and the result. Student Question: A study of long-distance phone calls made from General Electric Corporate Headquarters in [...]Read more