If you need assistance using Excel, you can access a tutorial that is appropriate for your experien 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 so If you have "DATA" already on the upper main menu, then simply click on it and you will open up a 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 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 TOOL 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 y The DATA ANALYSIS TOOLPAK provides 18 additional statistical tools in the areas of: Descriptive Statistics; Sampling; Hypothesis Testing; Analysis of Variance; Regression and Correl The ToolPak is valuable to business analysts and leaders who desire additional capability from th opriate for your experience level and your version of Excel. Mastering Excel 2013 ust be added in to the software before it can be used. it and you will open up a tool bar of assorted new Excel tools, including: s program into Excel by doing the following: re the ANALYSIS TOOLPAK is checkmarked and click OK. ou may have to consult your installation CD and reinstall the Excel set-up the areas of: ; Regression and Correlation; and Time Series Forecasting itional capability from the Excel software. Company North-East-West-South (NEWS) NEWS is struggling in the ultra-competitive high-tech market. They have called upon you and yo to make some key business decisions using the methods and tools recently learned throughou Save this file for each homework assignment as follows: Last Name_First Name_Homework #.xls F 2-1 Excel Homework I: Scatterplots This homework assignment will help you begin to familiarize yourself with the Excel software, creating Create a scatterplot from a given set of data and then create a regression fitted line and determine the 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, an In this assignment, you will create a histogram plot from a given set of data and then determine the me 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 p 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. NEWS has gathered data over the last 52 weeks. Two of the data items that have be Question 1: Using the data given below, complete Task 1 and provide a very brief, between Profit and the Number of Defective Items. ANSWER: Question 2: Using the data given below, complete Task 2 and provide a statistical d between Profit and the Number of Defective Items. ANSWER: Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Profit (thousands) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 35.00 490.00 777.00 922.00 519.00 520.00 899.00 391.00 577.00 419.00 667.00 399.00 540.00 954.00 1,078.00 563.00 619.00 625.00 351.00 674.00 547.00 578.00 609.00 Number of Defective Items 974 693 248 277 509 635 200 743 563 715 397 720 659 123 8 444 464 483 715 444 639 503 565 Task 1: Create a Scatterplot Step 1. Highlight the two columns of d Step 2. Click the Quick Analysis icon o Step 3. Select Charts and Scatter Place the Chart below this row Task 2: Correlation and Regression F Step 1. Place your mouse over any po Step 2. Select Linear, then scroll down 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 228.00 871.00 188.00 632.00 442.00 442.00 1,114.00 864.00 825.00 750.00 615.00 445.00 282.00 409.00 637.00 646.00 999.00 232.00 152.00 874.00 981.00 289.00 771.00 806.00 921.00 150.00 113.00 1,084.00 350.00 785 286 842 480 721 571 25 272 241 252 500 674 732 701 401 536 156 824 964 212 218 747 356 303 113 883 910 85 745 Step 3. Place the values in a visible ar Determine the Correlation Coefficient (R) CORRELATION COEFFICIENT = Check the Correlation Coefficient (R) by t Determine the sign (+ or -) of R based on CORRELATION COEFFICIENT = data items that have been gathered are Profit and the Number of Defective Items. d provide a very brief, general description of whether or not a relationship exists d provide a statistical description of whether or not a relationship appears to exist a Scatterplot t the two columns of data (Profit, Defective Units) Quick Analysis icon on the bottom right harts and Scatter below this row tion and Regression Fitted Line ur mouse over any point within your scatterplot above and right click. Then select Add Trendline. near, then scroll down and Display Equation and R squared Value on Chart e values in a visible area of the chart so that they are legible and not covered by any of the data orrelation Coefficient (R), using the CORREL function and highlighting each column (Profit, Defective). COEFFICIENT = ation Coefficient (R) by taking the square root (SQRT) of the R squared value in the chart above. gn (+ or -) of R based on the direction of the regression line. COEFFICIENT = Trendline