Mba 501 | Accounting homework help

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.