Category: Mathematics – Statistics

For this assignment, you are required to complete Problem 64 (p. 593) in Chapter 12 of your textbook. Use the appropriate Excel file templates from www.cengagebrain.com. Once complete, post your Excel Document in Waypoint. Show all work.

23-64) Let Yt be the sales during month t (in thousands of dollars) for a photography studio, and let Pt be the price charged for portraits during month t. The data are in the file Week 4 Assignment Chapter 12 Problem 64. Use regression to fit the following model to these data:
Yt = a + b1Yt1 + b2Pt + et
This equation indicates that last months sales and the current months price are explanatory variables. The last term, et, is an error term. MUST SHOW WORK!!!

1. If the price of a portrait during month 21 is $10, what would you predict for sales in month 21?
2. Does there appear to be a problem with autocorrelation of the residual? Explain your answer.

Length of stay (LOS) is a data set that is calculated on a daily basis for the patient demographics in order for the facility to understand the capacity and ability to accept new inpatient cases.  Depending on the job title, many different healthcare professionals view the data associated with LOS differently.

        

  Evaluation Title: Length of Stay Presentation

Explain in three to five sentences the relevance of LOS to a healthcare manager in a hospital setting. 

• Create a bullet point presentation for the board which includes administrators, physicians, other care providers and the stakeholders of the facility.  Include in the presentation:

1. The data points that need to be collected in order to calculate LOS.
2. An explanation of why each data point is vital to the overall statistical result.
3. A mock dataset of patient data to show the board how LOS is calculated (to ensure full explanation of ideas).

• Utilize at least two outside resources to support your assignment submission

 

1) Define and provide examples:

Central tendency measures

Mean

Mode

Median

Variation measures

Quartiles

Quintiles

Deciles

Percentiles

Ungrouped data

Grouped data

Range

Interquartile range

Variance

Standard deviation

Coefficient variation

Please use Style APA, cites and references and avoid plagiarism.

 

Description

“Today many big organizations are sitting on large chunks of data, not knowing what to do with it. They invite consultants & business analysts to have a look at data and come up with insights that could help the organization run their business better. There is no clear set of instructions in such open ended problems and it is expected of the consultant to do a lot of exploration first and formulate the problems themselves. These DVT projects fall into the bucket of such open ended problems and a specific problem statement has not been given intentionally. It is expected of students to explore the data and come up with good insights. There is no right and wrong answer here. There should a clear logical story which should come out of their submission.”

Please find below DVT Project instructions:

1. Please find the instructions here (attached, DVT project 1, PDF file)
2. To learn how to publish your tableau file, click here. (attached, document file)
3. Please use the following  datasets- (Car Claim Insurance.xlsx) (attached, excel sheet)

Note: 

Step 1:

Please upload the project on Tableau public and include the URL in the doc itself and upload it. 

Step 2: 

You need to add 1 page executive summary in the doc.

Step 3: 

• Insights/Findings (25%) Make sure you articulate your insights in the story caption.

Step 4:

• Story layout (25%) The story must be logical and address a specific purpose and audience. 

Step 5:

• Usability/Elimination of Visual Clutter (25%) Do ensure your story is interactive (Use of filters Parameters, Actions etc) and the overall view contains minimal clutter (Appropriate selection of Colours, size, tool tips).

Step 6: 

• Appropriate chart / Table selection (25%) Your selection of charts needs to aid in cognition. 

• Any assignment found copied/ plagiarized with another person will not be graded and marked as zero.
• Please ensure timely submission as post deadline assignment will not be accepted.

Grading Criteria

• Insights/Findings (25%) Make sure you articulate your insights in the story caption.
• Story layout (25%) The story must be logical and address a specific purpose and audience. 
• Usability/Elimination of Visual Clutter (25%) Do ensure your story is interactive (Use of filters Parameters, Actions etc) and the overall view contains minimal clutter (Appropriate selection of Colours, size, tool tips).
• Appropriate chart / Table selection (25%) Your selection of charts needs to aid in cognition. 

Regards,

Program Office

Scoring guide (Rubric) – Rubric – DVT (1)

CriteriaPoints1. Insights/Findings252. Story layout253. Usability/Elimination of Visual Clutter204. Appropriate chart / Table selection20Points90 

For this discussion, you will assess the use of various support decision tools and explain why outliers are sometimes called influential observations. Discuss what could happen to the slope of a regression of Y versus a single X when an outlier is included versus when it is not included. Will this necessarily happen when a point is an outlier? You are required to give at least two examples in your response.