MA145-B Assignment 2 Help

The default installation of your spreadsheet may not include the Data Analysis routines.

You should first check to see if they are using the following procedure:

1. Open the spreadsheet:
   
2. Pull down the tools menu and look for a Data Analysis item:
   • If it's there, the Data Analysis routines are installed
   • If it's not there, they need to be installed.
   
   In the example below, they are not installed:
   
3. Click on the Add-Ins item in the tools menu.
   The following dialog box should open:
   
4. Check the Analysis Toolpak checkbox, then the OK button:
   
5. Now the Tools pulldown menu should have a Data Analysis entry:
   The data analysis routines are now installed and ready to use.
   

1. Open the spreadsheet and pull down the Data menu.
   Select theImport External Data item and the Import Data subitem:
   
   
   
2. The following dialog box should open:
   
3. Use the dialog box to specify where your input file is located. This is what you would use if you had downloaded your file to the Desktop folder before starting:
   
4. Continue with the dialog:
   
5. Continue through the dialog:
   
   
   
   
   
   

1. Pull down the Data menu.
   Select theData Analysis item
   
2. The following dialog box appears:
   
3. Fill in the Input Range,
   check the Labels in First Row and Summary statistics boxes:
   
4. The result should be something like this:
   
   <\ol>

   Getting Percentiles from the Spreadsheet

   1. Pull down the Data menu.
      Select theData Analysis item,
      then Rank and Percentile
      
   2. The following dialog box should appear:
      
   3. Fill in the Input Range. Note that some versions of the spreadsheet program will go into a loop if the entire column is selected, so it's probably best to specify an exact range.
      If you select a range that includes the first row, check the Labels in First Row box.
      
   4. The results should be something like this:
      
   5. Calculating percentiles using the table
      Suppose we want to find the 95th percentile of the data using the table of percentiles in the above image. Here is the procedure:
      1. Read down the list to the last number with a value in the Percent column that is strictly greater than 95.00%.
         (In this list, it's row 8 with a value in the Percent column of 95.50% and a data value of 5.73E+00 or 5.73).
      2. Locate the row immediately below this one. This will be the first row in the table with value in the Percent column less than or equal to 95.00%.
         (In this list, it's row 9 with a percent value of 94.90% and a data value of 5.69E+00 or 5.69.)
      3. The average of the data values in these two rows is the 95th percentile.
         (In this example, the data values are 5.73 and 5.69, and their average is 5.71. 5.71 is the 95th percentile for this data).

   Getting a Histogram

   1. Pull down the Data menu.
      Select theData Analysis item,
      then Histogram
      
   2. Fill in the Input Range
      
   3. After expanding the chart, the results should look something like this: