Brilliant Answers

READ ME

	If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel.
	Access these tutorials at Atomic Learning using your SNHU login at:								Mastering Excel 2013
	The Data Analysis ToolPak is an add-in program for Microsoft Excel. It must be added in to the software before it can be used.
	If you have "DATA" already on the upper main menu, then simply click on it and you will open up a tool bar of assorted new Excel tools, including:
	Get External Data, Connections, Sort & Filter, Data Tools, Outline, and Analysis.
	If you do not see "DATA" on the upper main menu, then you must add this program into Excel by doing the following:
	Click FILE in the upper tool bar, followed by OPTIONS, then select ADD-INS.
	Next, on the bottom near Manage, select EXCEL ADD-INS and GO. Ensure the ANALYSIS TOOLPAK is checkmarked and click OK.
	This ToolPak will provide additional data analysis tools for statistics.
	NOTE: If you are unable to load this ToolPak into your version of Excel, you may have to consult your installation CD and reinstall the Excel set-up
	The DATA ANALYSIS TOOLPAK provides 18 additional statistical tools in the areas of:
	Descriptive Statistics; Sampling; Hypothesis Testing; Analysis of Variance; Regression and Correlation; and Time Series Forecasting
	The ToolPak is valuable to business analysts and leaders who desire additional capability from the Excel software.

Introduction

	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.

Template - Scatterplots

	NEWS has gathered data over the last 52 weeks. Two of the data items that have been gathered are Profit and the Number of Defective Items.
	Question 1: Using the data given below, complete Task 1 and provide a very brief, general description of whether or not a relationship exists
	between Profit and the Number of Defective Items.
	ANSWER:
	Question 2: Using the data given below, complete Task 2 and provide a statistical description of whether or not a relationship appears to exist
	between Profit and the Number of Defective Items.
	ANSWER:
	Week	Profit (thousands)	Number of Defective Items
	1	$ 35.00	974
	2	$ 490.00	693		Task 1: Create a Scatterplot
	3	$ 777.00	248		Step 1. Highlight the two columns of data (Profit, Defective Units)
	4	$ 922.00	277		Step 2. Click the Quick Analysis icon on the bottom right
	5	$ 519.00	509		Step 3. Select Charts and Scatter
	6	$ 520.00	635
	7	$ 899.00	200		Place the Chart below this row
	8	$ 391.00	743
	9	$ 577.00	563
	10	$ 419.00	715
	11	$ 667.00	397
	12	$ 399.00	720
	13	$ 540.00	659
	14	$ 954.00	123
	15	$ 1,078.00	8
	16	$ 563.00	444
	17	$ 619.00	464
	18	$ 625.00	483
	19	$ 351.00	715
	20	$ 674.00	444
	21	$ 547.00	639		Task 2: Correlation and Regression Fitted Line
	22	$ 578.00	503		Step 1. Place your mouse over any point within your scatterplot above and right click. Then select Add Trendline.
	23	$ 609.00	565		Step 2. Select Linear, then scroll down and Display Equation and R squared Value on Chart
	24	$ 228.00	785		Step 3. Place the values in a visible area of the chart so that they are legible and not covered by any of the data
	25	$ 871.00	286
	26	$ 188.00	842		Determine the Correlation Coefficient (R), using the CORREL function and highlighting each column (Profit, Defective).
	27	$ 632.00	480		CORRELATION COEFFICIENT =
	28	$ 442.00	721
	29	$ 442.00	571		Check the Correlation Coefficient (R) by taking the square root (SQRT) of the R squared value in the chart above.
	30	$ 1,114.00	25		Determine the sign (+ or -) of R based on the direction of the regression line.
	31	$ 864.00	272
	32	$ 825.00	241		CORRELATION COEFFICIENT =
	33	$ 750.00	252
	34	$ 615.00	500
	35	$ 445.00	674
	36	$ 282.00	732
	37	$ 409.00	701
	38	$ 637.00	401
	39	$ 646.00	536
	40	$ 999.00	156
	41	$ 232.00	824
	42	$ 152.00	964
	43	$ 874.00	212
	44	$ 981.00	218
	45	$ 289.00	747
	46	$ 771.00	356
	47	$ 806.00	303
	48	$ 921.00	113
	49	$ 150.00	883
	50	$ 113.00	910
	51	$ 1,084.00	85
	52	$ 350.00	745