Excel project help needed

INTRODUCTION TO EXCEL STAT PACKS

The Stat Packs are meant to supplement and broaden your understanding of statistics. Software can ease many of the necessary calculations, it is not, however, a replacement for statistical knowledge. All directions are given under the assumptions that students will be using Excel on a Microsoft device. All analysis will involve either the DATA ANALYSIS TOOL or STATISTICAL FUNCTIONS. ONCE IN EXCEL:

 To access STATISTICAL FUNCTION click on the Function Wizard icon, fx, located on the toolbar, to the immediate left of the input line.  To access the DATA ANYLSIS TOOL click DATA TAB on the toolbar. Data Analysis is available under the Analysis Group (far right corner of the Tool Bar.)

If you do not see Data Analysis you will need to load it into Excel. It is free. The following applies to Excel 2007, Excel 2010, Excel 2013, and Excel 2016. 1. Click the File tab, click Options, and click the Add-Ins category. If you're using Excel 2007, click the Microsoft Office Button, and then click Excel Options 2. In the Manage box select Excel Add-ins, click Go. 3. In the Add-Ins box, check the Analysis ToolPak check box, click OK.

• If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

• If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

The Data Analysis should now be loaded into Excel. MAC USERS: Many Excel versions for MAC do NOT have the Data Analysis. If this is the case for you and you cannot load it into your version, complete those sections requiring Data Analysis on another computer (such as those in the library).