14_Appendix_B (1) - Appendix B: Microsoft Excel Tutorials...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Appendix B: Microsoft Excel Tutorials TUTORIAL 1: CREATING DESCRIPTIVE STATISTICS T is tutorial discusses how to use the Data Analysis add-in in Excel to compute various descriptive statistics for data ranges. Adding the Add-Ins to the Tools Menu ±o use the Data Analysis toolkit, you’ll need to add it to your ±ools menu. (Continued) Step Action Result 1 Run Excel and select the ±ools menu from the menu bar. ±ools menu displays starting with Spelling. .., Auditing, and so on. 2 See if the option Data Analysis. .. appears at the bottom of the menu (aF er Options. ..). If you see the Data Analysis. .. menu option, skip to the next section, “Computing Descriptive Statistics for Spreadsheet Data.” If not, continue with step 3. 3 Select the Add-Ins. .. option in this menu (about halfway down the list). AF er several seconds, a new window, titled Add-Ins , will appear with several checkbox entries in a list. KPL-MBAFST-07-0702-Appendix B.in235 235 KPL-MBAFST-07-0702-Appendix B.in235 235 10/11/07 12:44:21 PM 10/11/07 12:44:21 PM
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Note: If you don’t see the Analysis Tookpak add-ins, you may not have performed a complete install of MicrosoF Offi ce (or Excel). Reinstall Offi ce (or Excel) with a full installation, or work with your IT department if you use Offi ce over a network. Now, we’re hopefully ready to use this toolpak to do some statistical analyses! Computing Descriptive Statistics for Spreadsheet Data Let’s start by entering some data into a blank spreadsheet to use for this (and future) tutorials. Input the information below into Sheet1 in Excel. Monthly Rates of Return Date S&P Viacom AT&T GM Coke 01/30/98 0.8799 0.7541 2.1407 -4.6296 -18.8406 02/27/98 7.5187 14.9701 -2.5948 18.9860 6.6964 03/31/98 5.5580 11.9792 7.7869 -1.7226 -3.3473 04/30/98 1.3716 7.9070 -8.5551 -0.5535 5.8442 05/29/98 -1.6289 -5.1724 1.2474 6.6790 1.9427 06/27/98 2.4171 3.4091 0.8214 1.8261 2.1063 ± ese are monthly rates of return for the stocks shown in the ² rst half of a past year. Now, let’s compute some simple descriptive statistics for Step Action Result 4 Check the boxes next to the Analysis Toolpak and Analysis Toolpak—VBA add-ins. Boxes next to these add-ins will be checked with a checkmark. 5 Also, it’s a good idea to check the AutoSave add-in so that Excel prompts you to save your work periodically. Box next to the AutoSave add-in will be checked. 6 Push the OK button to the right of the list of add-ins. Excel will now add in the functionality of these toolpaks. ± is may take a few seconds. 7 Repeat steps 1 and 2 in this list. You should now see the Data Analysis. .. option in the Tools menu. (Continued) 236 APPENDIX B: MICROSOFT EXCEL TUTORIALS KPL-MBAFST-07-0702-Appendix B.in236 236 KPL-MBAFST-07-0702-Appendix B.in236 236 10/11/07 12:44:22 PM 10/11/07 12:44:22 PM
Background image of page 2
these data, such as maximum, minimum, range, mean, median, variance, and standard deviation. To compute these, we could use the Function Wiz- ard and insert formulas for these statistics below the columns of data. But there’s an easier way to do more with less e± ort!
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 24

14_Appendix_B (1) - Appendix B: Microsoft Excel Tutorials...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online