smart

instructions.docx

Use Excel to perform an analysis of the practice quiz #1 that we have been using. Do as many of the tasks as you can. Explore the capabilities of Excel to sort analyze and display the data. Basic Excel will help with most of the tasks.

To get some additional help with tasks you should make use of one of the following:

“Analysis Tool Pack”

· To use the Toolpak, go to the Data Tab and select “Data Analysis” from the far right end

. Select Data Analysis, and use and review some of the basic statistical tools there.

. “Histogram” and “Rank and Percentile” should be useful. The rank and percentage function found in the data analysis tool box does not compute Q25 and Q75 exactly as we have discussed (it rounds to the next highest actual number in the list), but you may use the Excel computed values.

. Instructions for the use of these tools is built into Excel.

. Note that Box and Whisker charts are not part of “Analysis Tool Pack” but the basic statistics you need to draw your own are there.

· You may have to Load the Toolpak, if it doesn't show up at the far right end of the Data Tab. Here's a link to: MS Analysis Toolpak Instructions.pdf( in the folder)

. Under “File” you should select “Options”

. In the "Options” window, you should select “Add-Ins” from the left side

. At the bottom of the “Add-Ins” window, next to Manage: select "Excel Add-ins" and click "Go"

. In the Add-Ins box that appears, check the box next to “Analysis ToolPak” and click “OK”

READ THIS

Submit a well-formatted Excel analysis (both the xls file and a printout) to BBLearn before the specified due date/time. You may print directly to a pdf file, scan the printout, or take a clear photo of it. You may also draw your Box and Whisker, by hand, on a separate sheet or on the printout of the excel analysis and then submit a scan/photograph of the Box and Whisker.

By well formatted, I just want you to demonstrate your ability to format the pages that you hand in. That is, charts and graphs may not be cut in half and plotted on diferrentpages. Move things around and control the page layout so your printed product looks as professional as possible