as 1

MARKETING RESEARCH

LAB Assignment #1

Software (all programs): Microsoft Excel

Dataset: Access the file – sampledatasafety on Excel

Analyses:

Analyze the dataset and generate the following measures of central tendencies:

1. Mean/Average Incident Cost

2. Mode Incident Cost

3. Median Incident Cost

Instructions:

1. AVERAGE

To calculate the mean (average) Incident Cost, click on another blank cell, and type the following:

=AVERAGE(

then select the group of cells (column - Incident Cost).

2. MEDIAN

To calculate the median Incident Cost, find another blank cell, and type the following:

=MEDIAN(

then select the group of cells (column - Incident Cost).

3. MODE

To calculate the mode for Incident Cost, find another blank cell, and type the following:

=MODE(

then select the group of cells (column - Incident Cost).

Output:

Screenshot and save the output obtained on Excel and attach it as a document to Canvas