Explain the process used in the handling of the data

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?

User Account

All Pages