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.