Managerial accounting
Company North-East-West-South (NEWS) |
NEWS is struggling in the ultra-competitive high-tech market. They have called upon you and your analysis team to help them analyze their data in order |
to make some key business decisions using the methods and tools recently learned throughout MBA 501. |
Save this file for each homework assignment as follows: Last Name_First Name_Homework #.xls For example, Smith_John_Homework 2_1.xls |
2-1 Excel Homework I: Scatterplots |
This homework assignment will help you begin to familiarize yourself with the Excel software, creating graphs, and using the Data Analysis add-in feature. |
Create a scatterplot from a given set of data and then create a regression fitted line and determine the correlation coefficient. |
Provide a practical interpretation of the results. |
3-2 Excel Homework II: Descriptive Statistics |
This homework assignment will continue to familiarize you with the Excel software, creating graphs, and using the Data Analysis add-in feature. |
In this assignment, you will create a histogram plot from a given set of data and then determine the mean, median, and standard deviation. |
Provide a practical interpretation of the results. |
6-2 Excel Homework III: Amortization Table |
This homework assignment will continue to familiarize you with the Excel software. |
In this assignment, you will create an amortization table based on a given principal, interest rate, and payment longevity. |
Analyze alternative criteria to determine the optimal conditions. |
7-2 Excel Homework IV: Probability |
This homework assignment will continue to familiarize you with the Excel software. |
In this assignment, you will analyze a given business problem based on probability. |
Provide a practical interpretation of the results. |