Problem03-47

# Problem03-47 - Problem 3-47 Name NOTE You must have the...

This preview shows pages 1–2. Sign up to view the full content.

Problem 3-47 Name: NOTE: You must have the Data Analysis pack - an add-on for Excel - installed in order for the statistica analysis to function. The Data Analysis pack is a powerful set of tools used to figure out the variance, correlation and covariance of Although the Data Analysis pack is a standard feature that comes with Excel, it may not already be loaded into Data Analyis is usually found under the Tools menu. If it is not listed, you will have to add it. 3. It should just install the Data Analysis options from there. It may, however, require the original Microsoft Excel or Office CD to complete installation. 4. Now, under the Tools menu, Data Analysis should be listed. 1. 10 Month Instructions for Part 1 - 10 Months of Data Receiving 1. Enter the number of receiving hours and receiving cost for each month Month Orders as they appear in the text in the gray cells at the right. A red asterisk 1 will appear next to a row if both numbers are not correct. 2 3 2. On the menu, click on TOOLS, then DATA ANALYSIS. Select 4 REGRESSION from the list of choices in the Analysis Tools list. 5

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 07/13/2011 for the course ACC 202 taught by Professor Woollen during the Spring '08 term at Hawaii.

### Page1 / 4

Problem03-47 - Problem 3-47 Name NOTE You must have the...

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

View Full Document
Ask a homework question - tutors are online