AS 2

MARKETING RESEARCH

LAB Assignment #2

Software (all programs): Microsoft Excel

Instructions: Access the file - sampledatasafety

Analyses:

Analyze the dataset and generate the following:

1. Min (Minimum) days lost

2. Max (Maximum) days lost

Min will display the smallest amount in your data set. Max will display the largest amount in your data set.

Instructions:

1. MIN

To calculate the minimum , click on another blank cell, and type the following:

=MIN(

then select the group of cells (column – Days Lost).

2. MAX

To calculate the minimum , click on another blank cell, and type the following:

=MIN(

then select the group of cells (column – Days Lost).

Output:

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