For next week (Wednesday for Section #3 and Thursday for Sections 1&2) submit (using the provided cover sheet) an Excel analysis of the practice quiz that we have been using (in BbLearn). 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â€
Under â€œFileâ€ you should select â€œOptionsâ€
Under â€œOptionsâ€ you should select â€œAdd-Insâ€
Under â€œAdd-Insâ€ select â€œAnalysis Tool Packâ€ and select â€œGOâ€
Select â€œAnalysis Tool Packâ€ and then â€œOKâ€
You should see â€œData Analysisâ€ on the far right.
Select Data Analysis and use and review some of the basic statistical tools there.
Box and Whisker charts are not part of â€œAnalysis Tool Packâ€ but the basic statistics you need to draw your own are there.
â€œHistogramâ€ and â€œRank and Percentileâ€ should be useful.
Instructions for the use of these tools is built in.