excel assignment, accounting homework help

Anonymous
timer Asked: May 23rd, 2017
account_balance_wallet $5

Question Description

If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel.

Unformatted Attachment Preview

If you need assistance using Excel, you can access a tutorial that is appropriate for your experie 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 s If you have "DATA" already on the upper main menu, then simply click on it and you will open up 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 b 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 TOO 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 consul The DATA ANALYSIS TOOLPAK provides 18 additional statistical tools in the areas of: Descriptive Statistics; Sampling; Hypothesis Testing; Analysis of Variance; Regression and Corr The ToolPak is valuable to business analysts and leaders who desire additional capability from t and you will open up a tool bar of assorted new Excel tools, including: u may have to consult your installation CD and reinstall the Excel set-up Company North-East-West-South (NEWS) NEWS is struggling in the ultra-competitive high-tech market. They have called upon you to make some key business decisions using the methods and tools recently learned thro Save this file for each homework assignment as follows: Last Name_First Name_Homework #. 2-1 Excel Homework I: Scatterplots This homework assignment will help you begin to familiarize yourself with the Excel software, cr Create a scatterplot from a given set of data and then create a regression fitted line and determ 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 grap In this assignment, you will create a histogram plot from a given set of data and then determine 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 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. Company North-East-West-South (NEWS) NEWS is struggling in the ultra-competitive high-tech market. They have called upon you and you to make some key business decisions using the methods and tools recently learned throughout M Save this file for each homework assignment as follows: Last Name_First Name_Homework #.xls For 2-1 Excel Homework I: Scatterplots This homework assignment will help you begin to familiarize yourself with the Excel software, creating gra Create a scatterplot from a given set of data and then create a regression fitted line and determine the co 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 u In this assignment, you will create a histogram plot from a given set of data and then determine the mean 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 pay 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. d upon you and your analysis team to help them analyze their data in order NEWS understands the issues that they must overcome in terms of quality, speed, and NEWS believes that the analysis that your team has provided in the last three Excel m The NEWS BOD would like to understand the probability of this success before granti Data has been gathered on the last 50 process improvement program (PIP) projects th The BLUE columns describe whether the PIP was initially approved as a quality, spee The GREEN columns describe the quality, speed, and $ results from each project. Reg the positive or negative results were gathered in terms of quality, speed, and $ at the e The RED column describes the BOD final determination of whether the PIP was succe Question 1: Using the data given below, complete Task 1. The BOD would like to know has hindered their ability to remember the percentage that began as an effort to overc Also, briefly discuss the PIP success rate attributable to each type of PIP effort based ANSWER: Question 2: Using the data given below, complete Task 2. NEWS is very proud of thei Is this true? Explain. The BOD is very concerned about this next process improvement project decision. It i success criteria has been provided. Does the new criteria change the rate of success ANSWER: Combo PIP 1 2 3 4 5 6 7 8 9 10 11 Quality 1 1 1 1 1 1 Speed Costs 1 1 1 1 1 1 1 - 1 1 1 1 1 1 1 2 7 1 2 7 6 6 6 1 5 5 Quality Speed (Defective (Reduction Free out of in Days) 1000) 18 849 969 25 375 14 54 25 231 19 294 4 113 18 815 25 8 75 574 16 581 4 12 13 14 15 16 17 18 19 20 21 22 23 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 - 5 7 2 2 3 7 4 6 4 1 4 6 5 5 1 2 4 1 6 6 3 7 4 2 1 1 6 1 6 5 6 3 1 1 4 1 6 3 4 476 913 901 461 907 113 836 117 140 486 693 797 640 809 395 67 318 892 241 672 367 441 312 741 152 421 664 394 342 495 138 497 600 70 328 738 282 905 220 13 15 18 16 16 7 14 11 2 12 21 6 1 14 18 11 1 22 25 12 1 19 11 7 15 14 18 17 15 6 10 13 8 9 17 11 17 7 5 erms of quality, speed, and controlling costs. d in the last three Excel modules has led to successful strategic plans. his success before granting permission for the CEO to execute the plan. program (PIP) projects that the NEWS BOD had approved. proved as a quality, speed, or cost control project, or combination. (1 = Yes) lts from each project. Regardless of how the PIP was initially chosen, ality, speed, and $ at the end of the project. hether the PIP was successful or not; old BOD criteria were confidential. (1 = Yes) he BOD would like to know the percentage of PIP projects completed per each category, since their short-ter egan as an effort to overcome quality, speed, and cost issues. h type of PIP effort based on the BOD's confidential criteria shown only as success or failure Results. EWS is very proud of their PIP initiative and has briefed the press that their success rate is greater than 50% ment project decision. It is truly a make or break initiative for the company, and therefore a more conservati hange the rate of success of past PIP initiatives? Given this probability of success, what recommendation w Project Cost over 5 Years $ 18.786,00 $ (99.911,00) $ (127.462,00) $ 180.987,00 $ 141.891,00 $ (337.779,00) $ 359.480,00 $ (105.450,00) $ (358.460,00) $ 204.531,00 $ (423.775,00) Results 1 1 1 1 1 1 1 Task 1: Calculate Basic Probability of each PIP Step 1: Determine the number of Quality, Speed, or Costs projects Step 2: Highlight each BLUE column and use a criterion of 1 Step 3: Divide the COUNTIF value by the total number of PIP projec Step 4: Next, determine the number of combination projects using Step 5: Again, highlight each BLUE column now in question, and u Step 6: Find probability of PIP success due to quality, speed, or co Count Quality (1) PIP Percentage $ 27.067,00 $ 183.020,00 $ (189.459,00) $ (440.744,00) $ (121.543,00) $ 279.995,00 $ 119.375,00 $ 258.624,00 $ 490.621,00 $ (29.548,00) $ 429.546,00 $ 321.394,00 $ 338.079,00 $ 127.488,00 $ (452.635,00) $ (153.762,00) $ (87.959,00) $ 114.534,00 $ (155.861,00) $ (365.375,00) $ (47.545,00) $ (54.337,00) $ (25.565,00) $ 218.901,00 $ (174.572,00) $ 364.862,00 $ (285.424,00) $ 11.445,00 $ 381.951,00 $ (364.384,00) $ 126.225,00 $ 314.030,00 $ (204.767,00) $ (360.997,00) $ 312.224,00 $ 395.810,00 $ (437.307,00) $ 376.547,00 $ (183.168,00) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Speed (2) Costs (3) Q & S (4) Q & C (5) S & C (6) Q, S, C (7) Task 2: Calculate Basic Probability Using new BOD Success Crite Find the probability of PIP success in Results using the COUNTIF funct PIP Success (OLD) = Given the criticality of this new decision, the BOD has provided conserv Quality > 300 Defective Free per 1000 Speed > 15 Days Reduced Costs < $ 200,000 per 5 Years Find probability of PIP success using COUNTIFS due to new BOD qual PIP Success (NEW) = ory, since their short-term memory or failure Results. rate is greater than 50%. efore a more conservative set of what recommendation would you make to the BOD? peed, or Costs projects using the COUNTIF function. se a criterion of 1 tal number of PIP projects (which is 50) to determine % of each. bination projects using the COUNTIFS function. n now in question, and use a criterion of 1; divide value by 50 e to quality, speed, or costs or combination using COUNTIFS and COMBO 1-7; divide value by 50 PIP Success alue by 50 ...
Purchase answer to see full attachment

Tutor Answer

strongboss5
School: Purdue University

Kindly see attached file with the completed worksheet

If you need assistance using Excel, you can access a tutorial that is appropriate for your experie
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 s
If you have "DATA" already on the upper main menu, then simply click on it and you will open up
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 b
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 TOO
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 consul

The DATA ANALYSIS TOOLPAK provides 18 additional statistical tools in the areas of:
Descriptive Statistics; Sampling; Hypothesis Testing; Analysis of Variance; Regression and Corr
The ToolPak is valuable to business analysts and leaders who desire additional capability from t

and you will open up a tool bar of assorted new Excel tools, including:

u may have to consult your installation CD and reinstall the Excel set-up

Company North-East-West-South (NEWS)

NEWS is struggling in the ultra-competitive high-tech market. They have called upon you
to make some key business decisions using the methods and tools recently learned thro

Save this file for each homework assignment as follows: Last Name_First Name_Homework #.

2-1 Excel Homework I: Scatterplots
This homework assignment will help you begin to familiarize yourself with the Excel software, cr
Create a scatterplot from a given set of data and then create a regression fitted line and determ
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 grap
In this assignment, you will create a histogram plot from a given set of data and then determine
Provide a practical interpretation of the results.

6-2 Excel Homework III: Amortization Table
This homework ...

flag Report DMCA
Review

Anonymous
Excellent job

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors