Example 3-2 Population MeanVacation Ski Packages

Issue: Issue:

Determine the mean nightly revenue for the Determine the mean nightly revenue for the Foster City Hotel.Foster City Hotel.

Objective: Objective:

Use Excel to calculate the population mean Use Excel to calculate the population mean revenue Data File is revenue Data File is FosterCity.xlsFosterCity.xls

Open the Excel file called FosterCity.xls

Example 3-2 Population Mean

Option 1 – Use the Excel Average function.

Click the function wizard – Select Statistical category – Select Average

Example 3-2 Population Mean

Specify data range - Click OK

Example 3-2 Population Mean

Population Mean

Example 3-2 Population Mean

Optional Method: Select Tools, then Data Analysis

Example 3-2 Population Mean

Select Descriptive Statistics

Example 3-2 Population Mean

Define Data Range and select options

Example 3-2 Population Mean

Mean Revenue

Example 3-2 Population Mean

Example 3-6 Mean, Median and ModeWeigh-In-Motion

Example 3-6 Mean, Median and ModeWeigh-In-Motion

Issue: Issue:

Does the WIM scale produce gross weights Does the WIM scale produce gross weights that are close to the POE weights?that are close to the POE weights?

Objective: Objective:

Use Excel to develop histograms for the Use Excel to develop histograms for the weights from each scale and to compute the mean, weights from each scale and to compute the mean, median, and mode for each scale. The data file is median, and mode for each scale. The data file is Trucks.xls.Trucks.xls.

Open the data file called Trucks.xls

Data File contains 200 trucks. Last row is 201

Example 3-6 Mean, Median, and Mode

Optional method for determining the frequency distribution and histogram – use Pivot Tables – refer to example 2-8 in Chapter 2 for specifics

Example 3-6 Mean, Median, and Mode

Group the WIM weights by 10,000 pounds starting at 15,000 pounds (See Example 2-8 for specific steps required to group data.

Example 3-6 Mean, Median, and Mode

Highlight the frequencies and click on the Chart Wizard to develop “quick-and dirty” histogram

Example 3-6 Mean, Median, and Mode

Close Gaps by selecting bars – Right Clicking – select Format Data Series - then Options.

Example 3-6 Mean, Median, and Mode

Completed Histogram for WIM gross weights – Repeat the process for POE gross weights. Then compute mean, median and modes for both variables

Example 3-6 Mean, Median, and Mode

Select Tools – then select Data Analysis

Example 3-6 Mean, Median, and Mode

Click on Descriptive Statistics

Example 3-6 Mean, Median, and Mode

Define Data Range and select options

Example 3-6 Mean, Median, and Mode

Delete un-needed columns

Example 3-6 Mean, Median, and Mode

Mean, Median, and Mode

Example 3-6 Mean, Median, and Mode