I need help in statistics ( excel hw)

profileama586

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.

 

Also

 

Some of the machines in the building have “QI Macros” installed already. It would show up along the very top “ribbon” at the right next to “View”. If it is not there you may be able to load it yourself (especially on your private machine) but you may not have the privileges to add it to the university machines. If you have control of the machine you are using you can find information about “QI Macros” on the web.

 

Hand in a well formatted Excel analysis. You may draw your Box and Whisker on the Excel page as well.

You must demonstrate your ability to format the pages that you hand in. Charts and graphs may not be cut in half and plotted on diferrent pages. Move things around and control the page layout so your report looks as professional as possible.

 

  • 10 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    solution.xlsx