This week, we will learn to use Excel to perform Descriiptive Analysis. By using
This week, we will learn to use Excel to perform Descriiptive Analysis. By using these techniques we will be able to find the mean, median, mode, range, sum, count, and standard deviation of a data set.
Resource to consult: https://www.triolastats.com/es13-excel-videos Section 3-1
Data Sets
Required Data Set to download:
· 32 – Airport Data Speeds.xls
Assignment
Follow along with video 3-1 “Using Excel for Descriiptive Statistics” (https://www.youtube.com/watch?v=ciAOcm41R3M) using the data found in the spreadsheet labeled “32 – Airport Data Speeds”.
Complete the steps as shown in the video by performing them in your sample data sheet. Once you have completed all the steps shown in the video, save the completed sample data sheet as
W2_3-1_Airport.xls
Note that you are not required to complete the steps that use the XLSTATS Toolpack Add-in. You are only required to complete those steps shown after time stamp 2:49.
Submission:
You are to submit the following file in the assignment dropbox:
· W2_3-1_Airport.xls
Leave a Reply