| 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. ; |
|
|
|
|
|
