Category: Data Analytics

Frequency distribution homework
Constructing Frequency distribution Constructing

Frequency distribution homework
Constructing Frequency distribution Constructing Frequency distribution with 13 classes

Introduction
Business administrators and managers are often called upon to inter

Introduction
Business administrators and managers are often called upon to interpret data that analysts have provided to them. This requires an understanding of the data sources (when, where, and how data is collected; formatted or stored; and used), as well as what that data looks like and how it can be summarized. In this first assessment, you are asked to locate any report or periodical article used in a business context of interest to you that contains at least two different graphical representations of data. You will interpret the graphical data representations and present your findings in a brief PowerPoint deck, as if you were presenting during a company meeting.
In this assessment you will learn about the collection, formatting, and use of raw data, as well as graphical and tabular methods for summarizing it. You will also get started with the technology that you will use in this course: Microsoft Excel (including the Data Analysis ToolPak add-in).
Scenerio
You have been invited to present at a departmental meeting with employees from all levels within the organization. You have been allotted 6-10 minutes to speak.
Your role
The purpose of your speech is to explain the business context as well as two charts or tables that you have evaluated as a business analyst of the organization.
Your business report to the group will be a slide presentation with speaker notes and appropriate citations and references.
Instructions
Complete the following:
Article Identification. Use one of the articles listed under Article Options subheading below or find an article in Forbes or other business journal or an annual report from a publicly traded company that includes at least two data graphs or tables.The graphs should depict or represent data using pie charts, bar charts, tables, scatter plots, trend lines, et cetera.
Read the article and identify the business context. Business context includes organizational history, mission, product and services, environment, competitive advantage, competition, et cetera. You can also determine business context from additional sources (and you should).The company or organizational background information should help explain why the data are relevant. This will be the introductory information for your business report, presentation, or assessment.
Interpret your chosen data representations in the context of the business situation. The following are typical questions an analyst would use to interpret the data:What is being measured (the variables)?
What are the relationships among the variables?
What are the trends in the data?
How can the data be applied in the business context?
Create an effective 6-10 slide PowerPoint deck with detailed presenter’s notes (including citations and reference slides) elaborating on each point that will be presented at a departmental meeting. For example:Organization/business context.
Relevance/importance of information.
Source of data set and any limitations?
Graphic of data 1 – with interpretations of graph.
Graph of data 2 – with interpretations of graph.
Importance of data analysis in terms of business context.
Summary.
Reference slides.
An effective PowerPoint presentation for this purpose typically includes:
One title slide, APA formatted.
1-2 introduction slides explaining the business context.
Several slides. You should copy and paste (insert) the graphs or tables and include an appropriate citation. Each slide should include detailed speaker notes.
Several slides. Include your interpretation of each graphical data representation.
Conclusion slides in which you explain how the data may affect the business context or how it could be applied in your business context to inform decision making.
Slide with at least four APA-formatted references, including the source of each graph.
ARTICLE OPTIONS
For this assessment, you will need to choose among business articles from periodicals, annual reports of publicly traded companies, or published business reports to find two graphical representations of data.
A list of appropriate articles has been compiled for this assessment. You may select one of the articles from the following list or find your own suitable business article containing two graphical data representations.
Huang, N. S. (2019). Investing: The best funds for your 401K. Kiplinger’s Personal Finance, 73(12), 18-29.
Reacting to market volatility. (2020). Kiplinger’s Personal Finance, 74(2), 54-55.
Taxpayers weigh in on the new tax law. (2020). Kiplinger’s Personal Finance, 74(3), 50-51.
Woodley, K. (2020). A holistic bet on housing. Kiplinger’s Personal Finance, 74(2), 31.
Decarlo, S., Elam, D. G., Smyth, K., Agus, S., Austin, C., Hackett, R., Kowitt, B., Lashinsky, A., Lev-ram, M., Nusca, A., O’keefe, B., Roberts, J. J., & Wieczner, J. (2017). 100 fastest-growing companies. Fortune, 176(4), 157-163.
Growing, growing… gone! (2016). Forbes, 197(5), 28.
Lim, P. J. (2018). The 50 best mutual funds and 50 best ETFs. Money, 47(1), 86-91.
Meet the world’s richest. (2016). Forbes, 197(4), 26-27.
Salisbury, I. (2018). How we got here. Money, 47(1), 52-57.
Sorvino, C. (2016). Dollar days. Forbes, 197(4), 28.
Additional instructions
Your written communication should be free of errors that detract from the overall message, meet APA standards, and be unbiased with documented facts rather than opinion.
Remember to use and include at least four sources of information for your presentation.
Evaluation
By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:Competency 1: Explain how data management techniques and tools are used to support business decisions.Introduce the business context.
Explain how the data can be applied to the business context.
Competency 4: Present the results of data analysis in clear and meaningful ways to multiple stakeholders.Interpret, or explain the meaning of, the two different graphical representations of data.
Correctly format citations and references using current APA style.
Present content clearly, professionally, and logically for the identified audience.

1. Define the PROBLEM (in one or two sentences). In this definition make sure it

1. Define the PROBLEM (in one or two sentences). In this definition make sure it is clear whose problem it is, and why it is so important that somebody should worry about it. If there are several problems in the case, you must either choose the most important one or define the problem broadly so that the sub-problems are part of it. This is the most important part of the analysis, since you must aim at the right target in order to hit it.
2. Define the METHOD. (4Ps Methode) In one or two sentences explain what method you are going to use to solve the problem. A method could be interest arbitrage to pick the best investment, or hedging techniques to find the least-cost hedge, or some other theory or technique. The method is NOT the solution to the case.
3. Do the ANALYSIS. In this section, use most of your 1000 words to solve the problem. This should be reasonably easy, since you have already defined the problem carefully and told me what method you are going to use to solve it.
4. Draw some CONCLUSIONS. This may be a final paragraph in which you emphasize your solution to the problem and why it is best.

You are a project manager on a project that uses earned value management. The pr

You are a project manager on a project that uses earned value management. The project has the following budget and status:
Project Duration (months):
14
Current Reporting Period (month):
6
BAC:
$387,000
Cumulative PV:
$68,345
Cumulative AC:
$78,379
% of the project completed through the reporting period:
19%
Estimate to Complete:
$294,677
Part 1:
Based on this information, determine the following:
Cumulative EV
Schedule Variance (SV)
Schedule Performance Index (SPI)
Cost Variance (CV)
Cost Performance Index (CPI)
EAC (bottom-up)
VAC (bottom-up)
TCPI
Based on your calculations above, respond to the following:
What is the status of project accomplishment performance through the current reporting period? Why?
What is the status of project cost performance through the current reporting period? Why?
Is the project projected to complete overbudget or underbudget? Why?
Interpret the TCPI metric.
Part 2:
Based on your calculations above, an inexperienced and arrogant project analyst from the project management office has computed an additional metric: Cost Schedule Index, which equals SPI * CPI. He wants you to report this metric to the customer, instead of SPI and CPI separately. What should you do and why?
The program manager doubts your numbers. In particular, he does not believe your EAC number and requests that you calculate the EAC not assuming future performance will behave like past performance.
Compute EAC when cost performance is negative and schedule dates must be met: EAC = AC + [(BAC – EV) / (CPI × SPI)]
Compute EAC using actual costs to date and assuming ETC uses budgeted rate: EAC = AC + (BAC – EV)
Interpret the results of the EAC in a.
Interpret the results of the EAC in b.
Based on these new calculations, what do you think the program manager will request from you regarding the bottom-up EAC?
Part 3:
You are having a hallway conversation with the same project analyst who is now realizing that he may not know as much about earned value management as he thought when he joined the company. Still, he is convinced that the following statements below are correct. How would you respond to him based on each statement (i.e., formulate a specific response and supporting rationale for each statement below)?
EAC becomes Cumulative AC at project completion.
Cumulative EV can be greater than BAC at project completion.
EAC can be smaller than BAC at project completion.
ETC can be greater than 0 at project completion.
Submit an MS Excel file showing your completed calculations and including your responses to the indicated question

GB512-4: Create presentations that achieve a defined business purpose.
In this a

GB512-4: Create presentations that achieve a defined business purpose.
In this assignment, you will do some research on a product or service or an environmental initiative. Then, you will create an original presentation following the instructions below.
Checklist:
1) Prepare a Microsoft® PowerPoint® presentation with audio of no fewer than 12 and no more than 15 slides with speaker notes, and 3–4 bulleted points per slide, summarizing either:
An improvement to an existing product or service you have envisioned in the role of a product specialist at a company. You will present to the parent company’s marketing and sales department manager that produces the product or service.
OR
An environmental initiative you would like to propose to your local town council for consideration. It can concern air quality, waste recycling, water quality, mitigation of embankments or lake areas to prevent floods, etc.
2) Any short citations and a references slide must follow APA 7th edition format and citation style.
FOLLOW ATTACHED RUBRIC

You will be analyzing a case and communicating your results with a PowerPoint pr

You will be analyzing a case and communicating your results with a PowerPoint presentation.
In this assignment, you will be assessed based on the following outcomes:
GB513-4: Evaluate real-world situations and present solutions using statistical methods.
PC-6.1: Incorporate data, inferences, and reasoning to solve problems.
The data you need for Part 2 is provided in the following Excel file. Be sure to use this file and do not type anything manually from the case or use other sources for the data.
Excel Spreadsheet for Part 2
Assignment Details
You will be analyzing the “Colonial Broadcasting” case. This can be found in the course pack you needed to purchase from Harvard Business Review at the beginning of the term. If you still need to purchase it, instructions and a link can be found in the syllabus. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore everything in the case document after the end of page 4.
The executives at CBC have four main areas in which they are interested: They want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months. They also want to know if hiring stars makes a difference and the impact of fact-based programming compared to hiring stars.
Remember that your audience is the management of CBC. Therefore, make sure your presentation is professional. Once you present your results, you need to justify and explain your findings with properly stated conclusions.
Answer the following questions:What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that compares these averages.
Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks (one column for each network).
Comment on how the networks are performing, by comparing and interpreting the metrics in the descriptive statistics table. Your analysis must extend beyond simply comparing the average ratings for each network.
Create a scatter graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months; you will need to calculate an average for each month first, and then plot the averages. After you create the graph, fit a linear trend line and a 2nd order polynomial trend line, displaying the formula and the r-squared. Explain to the executives if you can use this time series data to forecast the ratings of upcoming months. Which forecasting method is better? How accurate can you expect this forecast to be?
The executives wish to know if they should hire stars for their programs. To answer this question, run a hypothesis test to see if the ratings of shows with stars are higher compared to those without stars. Use the data for CBC movies only. Use 95% confidence.
Your answer should include the following:The null and alternative hypotheses (state in full sentences).
The test results: Run the test using Excel and include the output table. Use a t-test assuming equal variances.
What is your recommendation to the executives? Justify your answer referring to the relevant figures.
Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions:Executives wish to know how much being fact-based or having one star contributes to a movies rating. What can you tell them about this?
Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures.
How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring to the relevant figures.
Directions for Submitting your Assignment:
For this project, you will prepare a PowerPoint presentation to present your findings. The first slide after the title slide should be an “Executive Summary.” It should contain a very brief overview of all the answers. Your final slide should include “conclusions” and provide an overall assessment of the analysis.
Make sure you also submit the Excel file to show your work for Part 2. You will receive a 100-point reduction if you fail to include the Excel file showing your work.
Place all calculations for each of the questions on a separate worksheet. Then, using the results of your work from Excel, prepare PowerPoint slides to answer the questions in a presentation format. All relevant content should be on the slides; do not use the notes section or leave information in the Excel file. The executives reviewing the presentation should not need to switch to another document to see the required information.
The data you need is provided to you in the Unit 10 Excel file in Course Documents. Make sure to use that file. Do not type anything in manually or download anything from the Internet.

For this assignment, using ERD Plus complete the following from the textbook Cha

For this assignment, using ERD Plus complete the following from the textbook Chapter 2: E2.2 (complete a unique ER Diagram for EACH part a-m) and 1 mini case of your choosing out of MC3, MC4, MC5, or MC6 (note: clearly indicate which MC you are responding to on your document).
I Have attached both documents needed to answer this assignment question.
https://erdplus.com/

CriteriaRatingsPts
This criterion is linked to a Learning OutcomeProfessionalismSubmission was on time, well formatted, and clearly communicated the solutions to the problems (0-5 pts).
5 ptsFull Marks
0 ptsNo Marks
5 pts
This criterion is linked to a Learning OutcomeCompletenessReasonable attempts were made at every problem. Submission demonstrates that sufficient time and effort were give to the assignment (0-10 pts).
10 ptsFull Marks
0 ptsNo Marks
10 pts
This criterion is linked to a Learning OutcomeAccuracySubmitted answers were correct. Not every incorrect answer will be marked. Students should compare their submission with the answer key and reach out if still unsure how to produce the correct answer (0-5 pts).
5 ptsFull Marks
0 ptsNo Marks
5 pts
Total Points: 20

Please create a process map with below steps. Thank you – I don’t know where to

Please create a process map with below steps. Thank you – I don’t know where to create it in Microsoft word, excel, powerpoint, publisher or VIZIO. Please let me know which application you will use so I can make sure I have it on my computer. THANK YOU!
Step 1: Declare intent to manager
Step 2: Manager to inform Director and PPL
Step 3: Manager, PPL, and Director meet to discuss support or opportunities (Outcomes are either: move forward or reapply in 6 months)
Step 4: Manager/Director to sign declaration of intent form. If not approved define goals and expectations on how to meet RNIII requirements. Step 5: Manager informs staff member of decision
Step 6: Move forward with promotion plan: Staff member to complete packet. If not moving forward with promotion: Staff member to work on opportunities & reapply in 6 months.
Step 7: Staff member to schedule meeting with manager, PPL, and Director to present packet a minimum of 5 business days prior to deadline.
Step 8: Team will meet and make final decision within 2 business days of packet receipt.
Step 9: If accepted Director will submit the completed packet to the promotion committee. If not accepted, employee will have an opportunity to make edits and resubmit within 1 business day.

Please create a process map with below steps. Thank you – I don’t know where to

Please create a process map with below steps. Thank you – I don’t know where to create it in Microsoft word, excel, powerpoint, publisher or VIZIO. Please let me know which application you will use so I can make sure I have it on my computer. THANK YOU!
Step 1: Declare intent to manager
Step 2: Manager to inform Director and PPL
Step 3: Manager, PPL, and Director meet to discuss support or opportunities (Outcomes are either: move forward or reapply in 6 months)
Step 4: Manager/Director to sign declaration of intent form. If not approved define goals and expectations on how to meet RNIII requirements. Step 5: Manager informs staff member of decision
Step 6: Move forward with promotion plan: Staff member to complete packet. If not moving forward with promotion: Staff member to work on opportunities & reapply in 6 months.
Step 7: Staff member to schedule meeting with manager, PPL, and Director to present packet a minimum of 5 business days prior to deadline.
Step 8: Team will meet and make final decision within 2 business days of packet receipt.
Step 9: If accepted Director will submit the completed packet to the promotion committee. If not accepted, employee will have an opportunity to make edits and resubmit within 1 business day.

Question 1
How are the values of Charleson Score distributed for our stroke pati

Question 1
How are the values of Charleson Score distributed for our stroke patients? Is it normally distributed, or not?
Yes, Charleson Score is normally distributed.
No, Charleson Score is not normally distributed.
Question 2
The mean and the median values are the same for completely normally distributed data. How much do they differ when looking at the patient’s age in this dataset?
Fill in just the value, i.e. 4.7, without labels.
Integer, decimal, or E notation allowed
Question 3
What is the mean SASI (Stroke Administrative Severity Score) Index for patients who have a history of Acute Ischemic Stroke and those who don’t?
Fill in just the value, i.e. 4.7, without labels.
a. Enter the mean SASI for patients who have a history of Acute Ischemic Stroke:
Integer, decimal, or E notation allowed
Question 4
What is the mean SASI (Stroke Administrative Severity Score) Index for patients who have a history of Acute Ischemic Stroke and those who don’t?
Fill in just the value, i.e. 4.7, without labels.
b. Enter the mean SASI for patients who do not have a history of Acute Ischemic Stroke:
Integer, decimal, or E notation allowed
Question 5
We’re going to assume for the purposes of this exercise that the Age variable is a normally distributed continuous variable.
Is the mean difference in age for patients who died during hospitalization and those who didn’t statistically significant at p<0.05? Yes, the difference in mean age between the groups is statistically significant. No, the difference in mean age between the groups is not statistically significant. Question 6 Is the SASI (Stroke Administrative Severity Score) Index of the stroke patients normally or non-normally distributed? The mean SASI score is normally distributed. The mean SASI is not normally distributed. Question 7 What is the mean total patient charge in this data set? *When entering your answer, omit the $ and any commas from your answer, i.e. $31,892.92 should be entered as 31893* Integer, decimal, or E notation allowed Question 8 Assume that the Charlson score is not normally distributed and that it is a continuous variable. Is there a statistically significant difference in Charlson Score for patients with a history of Acute Ischemic Stroke and those without at p=0.05? Yes, there is a statistical significant difference in Charlson Score for patients who have and do not have a history of acute ischemic stroke. No, there is not a statistical significant difference in Charlson Score for patients who have and do not have a history of acute ischemic stroke. Question 9 True or false: More men in this dataset received tPA than women. True False Question 10 What percent of patients had tPA administered were women? Fill in just the value, i.e. 4.7, without labels. Integer, decimal, or E notation allowed Question 11 What was the p-value of the Pearson Chi-Square statistical test in the previous question (What percentage of patients had tPA administered were women?)? Fill in just the value, i.e. 4.7, without labels. Integer, decimal, or E notation allowed Question 12 At a p<0.05 level of significance, is the difference between males and females receiving tPA statistically significant? Yes, the difference between men and women receiving tPA is statistically significant.