Brilliant Answers

module_3_excel.xlsx

Home >Mathematics homework help >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, and 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.

https://www.atomiclearning.com/highed/mastering-excel-2013-bigger-brains-training?cn=snhu

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 - Statistics

NEWS customers require a delivery time of 30 days at their door from the date that the order was received.
NEWS has provided data of their last 50 shipments: Duration = Delivery Date at the Door - Date Order was Received
Question 1: Using the data given below, complete Task 1 and provide a very brief, general description of whether or not you believe
NEWS is effectively satisfying their customer's desired shipment date.
ANSWER:
Question 2: Using the data given below, complete Task 2 and provide a brief statistical description of how the results
relate to the customer's requirements.
NOTE: A statistically significant answer to the question requires a hypothesis test using inferential statistics, which is not required.
ANSWER:
Order	Duration (Calendar Days)
1	11
2	30	Task 1: Create a Histogram
3	19	Step 1: Select DATA from the tool bar above and then the DATA ANAYSIS TOOL icon on the far right.
4	35	Step 2: Select HISTOGRAM, and in the Input Range, highlight the column of DURATION (Calendar Days).
5	13	Step 3: Leave the Bin Blank (Excel will determine this for you). In "New Worksheet Ply" type "Histogram Bins"
6	39	Step 4: Excel creates a new Worksheet named Histogram Bins with a count of each data point per Bin.
7	4	Step 5: In the Histogram Bin worksheet, highlight the data and then select the Quick Analysis icon.
8	23	Step 6: Select Charts. Select Clustered Vertical Bars and then repeat and select Lines.
9	34	Step 7: The first provides a Histogram; the second provides a Frequency Plot.
10	37	Place the Histogram and Frequency Plot side by side below this row
11	6
12	24
13	9
14	26
15	35
16	25
17	5
18	18
19	14
20	29
21	20
22	25
23	21
24	24
25	22
26	13
27	14
28	28
29	26
30	34
31	18
32	40
33	15
34	18
35	29
36	26
37	23	Task 2: Descriptive Statistics
38	36	Step 1: Select DATA from the tool bar above and then the DATA ANAYSIS TOOL icon on the far right.
39	42	Step 2: Select DESCRIPTIVE STATISTICS, and in the Input Range, highlight the column of DURATION (Calendar Days), Grouped by Columns.
40	33	Step 3: In "New Worksheet Ply" type Descriptive Statistics and Excel creates a new Worksheet containing the calculations.
41	15	Step 4: Check the box SUMMARY STATISTICS. Open the new worksheet and observe: Mean, Median, and Standard Deviation.
42	22
43	39	MEAN =
44	22
45	21	MEDIAN =
46	14
47	16	STD DEV =
48	44
49	18
50	22