Explain the process used in the handling of the data

Assignment Help Other Subject
Reference no: EM132229996

Assignment

The purpose of this assignment is to use spreadsheet capabilities to perform data manipulation and to explain the process used in the handling of the data.

For this assignment, you will use the "Claims" dataset. In the dataset, the claims data for n = 608 people are recorded. The data derive from a random sample of females diagnosed with ischemic heart disease over 24 months.

Instead of using urgent care centers, some people rely on the Emergency Room (ER) to address most, if not all, of their medical needs. In fact, someone who has three or more ER visits within 24 months is considered a high ER user. Complete the steps below to execute this assignment.

Using the dataset and Excel, create a new column titled "High_ER_User" with "Yes" if three or more ER visits; otherwise "No."

Duration is measured in days, but 30-day intervals are more appropriate for most reporting purposes. Using Excel, create a new column titled "Duration_Months" by converting the duration into 30-day intervals.

Many times complications and comorbidities are rare; therefore, these two negative events are summed together. Using Excel, create a new column titled "Comps_Comorbs" by adding complications with comorbidities.

Many times age is grouped in 10-year intervals. Using Excel's VLOOKUP function, create a new column titled "Age_Group" with grouped ages of "21-30 yrs," "31-40 yrs," and so on for 10-year intervals. The last age group would be "61-70 yrs." Use a tab titled "Age_Groups" for this task.

Next you will create a pivot table with the data and execute the following (refer to the examples in the resource "Data Manipulation Screenshots").

Use "High_ER_User" as a filter to obtain two filtered views of the pivot table.

Summarize the data to get counts of claims, sum of claims and months, and average of procedures, prescribed drugs, ER visits, and complications/comorbidities.

Add a calculated field titled "Claims PM" to the pivot table. This calculated field is the sum of claims divided by the sum of duration months and measures the average claim amount per month (PM).

Attachment:- Assignment Files.rar

Reference no: EM132229996

Questions Cloud

Workplace respectful workplace policy : Obtain a copy of your workplace's Respectful Workplace Policy or from any other source that is publicly available.
Customer relationship management-knowledge management : How electronic commerce software works with customer relationship management, knowledge management, and supply chain management software?
Organizational design and strategy at nov core technology : How does each of the following situational influences on organizational design affect organizational design and strategy at NOV core technology,
The process of purchasing appropriate parcel of real estate : The process of purchasing an appropriate parcel of real estate on which to build a large mill making paper from recycled cardboard.
Explain the process used in the handling of the data : The purpose of this assignment is to use spreadsheet capabilities to perform data manipulation and to explain the process used in the handling of the data
Lowering costs and boosting differentiation : Horizontal integration helps in reducing competitive intensity, lowering costs, boosting differentiation, and providing access to new markets
Explain how the given two items may influence the price : There are many different factors that influence the price a company must establish. One aspect of the price that can be established is the brand image.
Demand transportation services into foreign markets : Which of the following is NOT a possible reason why Uber opted to expand its on-demand transportation services into foreign markets?
Difference between health care law and health care ethics : What is the difference between health care "law" and health care "ethics"? What does the term bioethics mean?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd