Category: Statistics homework help

Complete the following and submit it in a Word document. Be sure to show your process and calculations:
Assume you have just retired as the CEO of a successful company. A major publisher has offered you a book deal. The publisher will pay you $1 million upfront if you agree to write a book about your experiences. You estimate that it will take three years to write the book. The time you spend writing will cause you to give up speaking engagements amounting to $500,000 per year. You estimate your opportunity cost to be 10%.

Should you accept this deal? Plot a diagram that measures NPV (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRR for this deal. (Hint: IRR is the point at which NPV = 0)

Suppose you inform the publisher that it needs to sweeten the deal before you will accept it. The publisher offers $550,000 advance and $1,000,000 in four years when the book is published.

Should you accept or reject the new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRRs for this deal (Hint: There are two IRRs for this problem).
Discuss if the IRR rule for making budgetary decisions can be used in this case.

Finally, you are able to get the publisher to increase your advance to $750,000, in addition to the $1 million when the book is published in four years.

Should you accept or reject this new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRR for this deal.

State three conclusions regarding the use of IRR vs. NPV that you can make from questions 2-4. Which is the stronger method to use (IRR or NPV), and why?

This activity consists of two problems.
Problem One
Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019. He was somewhat surprised to see the high number of what is classified as “late surgeries.” He has asked you, a quality analyst, to examine this data.
He requests the following items from you:
Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.
Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.
Create separate control charts in Excel for the number of late surgeries and the overall number of surgeries with a 95% confidence level. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.
Late Surgeries versus Overall SurgeriesMonthNumber of SurgeriesNumber of Late SurgeriesJanuary435112February401129March572186April409103May57789June329156July467156August30194September23589October325127November378156December444124Total48731432
Problem Two
Dr. Amanda Guzik, head of infectious diseases for Forest Medical Center in Lake Park Illinois, asks you to analyze the following influenza data that she has collected over five years from cases that were treated at this medical center.
Use Excel to create a run chart for the data.
Use Excel to create a control chart with a 95% confidence level for this data. Include the mean, the LCL, and the UCL. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.
Submit Word document(s) and Excel file(s) showing your responses and calculations.
Influenza Data by QuarterYearQuarter# of Cases of Influenza Observed11345212346134831439842141202237623429243583314219323853339234361441356842439433264441035142095239653411544008

Dr. William Jones has been the director of the health center clinic at East-Southern Kentucky Community College (ESKCC) for about six months. Having been a part of a much larger medical center in the past, he has seen the benefits of total quality management (TQM) and feels that it would help improve the operations at the ESKCC clinic. He has made some positive changes to the staffing of the clinic but now feels that he must tackle making improvements to its operations. Consequently, he has created a TQM team (of which you are a part) and has made certain that they have received the necessary training to start examining the various processes within the health center’s operations.
The ambulatory health service department of the ESKCC health center clinic has received increased complaints from the ESKCC student body and staff concerning the services it offers in its walk-in urgent care clinic. Dr. Jones feels that this center would be an excellent starting point for the TQM team.
The Data
The team is presented with the following data regarding student/staff complaints:
Patient Complaint DataMonthComplaint Type 1Complaint Type 2Complaint Type 3Complaint Type 4Complaint Type 5Complaint Type 6Total VisitsSeptember3141174813115841October21278411152971November1148112428311175December7144121738121042January153012141741671February21626128511631March27951623641512April4734313153781May421217182473Total248402872091543119097Complaint Type DescriptionsComplaint TypeComplaint Description1The quality of service received.2The waiting time was too long.3Follow-up care was not available.4The clinic was hard to find in the health center.5The medical care/treatment took too long.6The medical center could not find the individual’s medical records.
The Patient Review Process
The process for a patient (either a student or a staff member) coming in because of a problem is as follows:
When a patient arrives at the clinic, the patient first sees the receptionist, who checks to see if the patient was seen before. If so, the receptionist pulls the medical record from the file. If the patient is new, the receptionist has the patient complete the necessary forms and creates a medical record.
Patients are seen by the physician in the order they arrive. If one of the two examination rooms is empty, the nurse escorts the patient to the examination room and records the patient’s medical complaint. If no examination rooms are available, the nurse escorts the patient to a waiting area until an examination room is available.
When the patient is in the examination room, the nurse performs routine tests. The nurse then writes the complaint and findings on a medical examination form, a form that will be subsequently filed with the patient’s medical record.
The physician examines the patient and orders medical tests, if necessary. A diagnosis and treatment plan is presented to the patient by the physician; a written copy of this plan and any other appropriate instructions are written on the medical examination form.
When the physician releases the patient, the patient returns to the receptionist, who prepares a bill. If the patient has health insurance, the bill is sent to the health insurance carrier.
The patient leaves after either paying the bill (by cash, check, or credit card) or signing the forms to authorize payment by his or her health insurance company. If the health insurance company refuses to pay or partially pays the bill, the receptionist bills the patient by mail. Any patient with an unpaid bill or bad credit history is refused subsequent treatment until the old bill is paid.
Instructions
As a member of the ESKCC TQM team, you are asked to put together a report that recommends improvements to the overall patient process. Create a 4–6 page report in a Word document (copy and paste any charts created in Excel) addressing the following tasks:
Construct a Pareto Chart for the data regarding complaints to the health center that is presented in Table 1. Describe two conclusions from examining this data.
Develop a control chart for the waiting time complaint (complaint #2). Explain how the control chart is developed and show the calculation process.
Illustrate the causes for Complaint #2 in a fishbone diagram. (Note: refer to the readings for examples.)
Develop a flow chart for the process that the clinic uses for a patient who comes into the ambulatory center. Draw two conclusions from examining the flow chart regarding either or both of the following:
How the process affects the patient.
Potential sources of unnecessary complexity.
Determine three improvements to streamline the patient process based on the insights that you gain from examining the process flow chart as well as your understanding of total quality management concepts from your course readings.
This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. Check with your professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Propose improvements to a health services organization based on total quality management (TQM) concepts.

Complete the following and submit it in a Word document. Be sure to show your process and calculations:
Assume you have just retired as the CEO of a successful company. A major publisher has offered you a book deal. The publisher will pay you $1 million upfront if you agree to write a book about your experiences. You estimate that it will take three years to write the book. The time you spend writing will cause you to give up speaking engagements amounting to $500,000 per year. You estimate your opportunity cost to be 10%.
Should you accept this deal? Plot a diagram that measures NPV (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRR for this deal. (Hint: IRR is the point at which NPV = 0)
Suppose you inform the publisher that it needs to sweeten the deal before you will accept it. The publisher offers $550,000 advance and $1,000,000 in four years when the book is published.
Should you accept or reject the new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRRs for this deal (Hint: There are two IRRs for this problem).
Discuss if the IRR rule for making budgetary decisions can be used in this case.
Finally, you are able to get the publisher to increase your advance to $750,000, in addition to the $1 million when the book is published in four years.
Should you accept or reject this new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).
Determine the IRR for this deal.
State three conclusions regarding the use of IRR vs. NPV that you can make from questions 2-4. Which is the stronger method to use (IRR or NPV), and why?

This activity consists of two problems.
Problem One
Dr. Raymond Hill, Director of Surgery, for Forest Medical Center in Lake Park, Illinois, received some recent statistics concerning data on the surgeries performed in his center during 2019. He was somewhat surprised to see the high number of what is classified as “late surgeries.” He has asked you, a quality analyst, to examine this data.
He requests the following items from you:
Create a scatter plot in Excel of the number of late surgeries versus the overall number of surgeries.
Create a run chart in Excel for the number of late surgeries and a run chart for the overall number of surgeries for 2019.
Create separate control charts in Excel for the number of late surgeries and the overall number of surgeries with a 95% confidence level. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions regarding these three analyses regarding the late surgeries at Forest Medical Center.
Late Surgeries versus Overall SurgeriesMonthNumber of SurgeriesNumber of Late SurgeriesJanuary435112February401129March572186April409103May57789June329156July467156August30194September23589October325127November378156December444124Total48731432
Problem Two
Dr. Amanda Guzik, head of infectious diseases for Forest Medical Center in Lake Park Illinois, asks you to analyze the following influenza data that she has collected over five years from cases that were treated at this medical center.
Use Excel to create a run chart for the data.
Use Excel to create a control chart with a 95% confidence level for this data. Include the mean, the LCL, and the UCL. Show all calculations that you use to arrive at these control charts.
In a Word document, draw two conclusions from these charts regarding the influenza cases that the Forest Medical Center had treated.
Submit Word document(s) and Excel file(s) showing your responses and calculations.
Influenza Data by QuarterYearQuarter# of Cases of Influenza Observed11345212346134831439842141202237623429243583314219323853339234361441356842439433264441035142095239653411544008

 Instructions
Final Project Assignment Instructions
Scenario Background:
A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.
You work for Mercer Human Resources. The Mercer Human Resource Consulting website lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.
More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.
https://mobilityexchange.mercer.com/Insights/ cost-of-living-rankings#rankings
Assignment Guidance:
In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.
You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).
Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.
Deliverable Requirements:
This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.
The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview. How to Write an Executive Summary That Gets the Job Done 2023.pdf
Things to Consider:
To help you make this decision here are some things to consider:
Based on the MLR output, what variable(s) is/are significant?
From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?
It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.
Based on the descriptive statistics, for the significant predictors, what city has the best potential?
What city or cities fall are below the median?
What city or cities are in the upper 3rd quartile?

 APA formatting is ALWAYS expected. You may work in Excel , JASP or both
DIRECTIONS for Initial Post 
1) Select the ONE continuous variable from the database to use. State your choice
2) Select ONE categorical variable from the database (your choice). State your choice
3) Generate a random sample of 20 records from each of your levels of categories for your variable selected in #2. Post the file (in .csv format) , that contains only your generate random sample, to your post
4) Generate a descriptive statistics table by groups from your  sample.  Post your descriptive statistic table , in APA format, to this  thread.
5) Using your sample, generate a series of boxplots within ONE CHART which shows the spread of the continuous variable (from #1) for each group of your category variable. 
6) In JASP or Excel run a one-way ANOVA test, using the continuous  variable, over the groups of your selected categorical variable. Copy  and paste your ANOVA tables into your post. 
7) Use complete sentences to write an interpretation of the p value from your ANOVA table.  What does your p-value results suggest about the groups ?

1. In some ordering problems, like the one for Sam’s Bookstore, whenever demand exceeds existing inven- tory, the excess demand is not lost but is filled by expedited orders—at a premium cost to the company. Change Sam’s model to reflect this behavior. Assume that the unit cost of expediting is $40, well above the highest regular unit cost.
2. In the Sam’s Bookstore problem, the quantity discount structure is such that all the units ordered have the same unit cost. For example, if the order quantity is 2500, then each unit costs $22.25. Sometimes the quantity discount structure is such that the unit cost for the first so many items is one value, the unit cost for the next so many units is a slightly lower value, and so on. Modify the model so that Sam’s pays $24 for units 1 to 1500, $23 for units 1501 to 2500, and $22 for units 2501 and above. For example, the total cost for an order quantity of 2750 is 1500(24) 1 1000(23) 1 250(22). (Hint: Use IF functions, not VLOOKUP.)
3. Continuing Problem 1, create a two-way data table for expected profit with order quantity along the side and unit expediting cost along the top. Allow the order quantity to vary from 500 to 4500 in incre- ments of 500, and allow the unit expediting cost to vary from $36 to $45 in increments of $1. Each col- umn of this table will allow you to choose an opti- mal order quantity for a given unit expediting cost. How does this best order quantity change as the unit expediting cost increases? Write up your results in
a concise memo to management. (Hint: You will have to modify the existing spreadsheet model so that there is a cell for expected profit that changes automatically when you change either the order quantity or the unit expediting cost.)

Hello, 
I am seeking assistance with a statistics assignment. All information regarding the assignment is attached for your review. Thank you!
Here is the link to the suggested video for assistance with the assignment:

  “Regression analysis is a statistical tool that is used for two main purposes: description and prediction.”
Based on the outcome, provide a current event of a business application using regression analysis for decision-making.
Be sure to respond to at least one of your classmates’ posts. Cite any resources used. 500 words.