2-1 Excel Homework I: Scatter Plots
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 scatter plot from a given set of data, 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. 
    • 7 years ago
    Good Solutions Answer All Your Question
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      mba_501_probability_excel_hw_assignment.xls