Question: Please post pictures of excel Using EXCEL Descriptive statistics (using Excel data analysis tool) Generally one of the first things to do with new data

Please post pictures of excel

Using EXCEL Descriptive statistics (using Excel data analysis tool) Generally one of the first things to do with new data is to get to know it by asking some general questions like but not limited to the following: - What variables are included? What information are we getting? - What is the format of the variables: string, numeric, etc.? - What type of variables: categorical, continuous, and discrete? - Is this sample or population data? After looking at the data you may want to know - How many males/females? - How many count in each race - A break down of patient by Diagnosis, Gender, Age - What is the percentage of population by age - How many count by ethnicity? Using the Patient Dataset (attached), review the data to make those determination Complete a Descriptive Analysis by providing various solutions to respresent the data a. Descriptive Statistics - Summary of Age b. Histogram - Bin: 20 - 99 (increment of 10) c. Percentile by Age (range: 5%99% ) d. Count of variables - Gender, Race, Diagnosis e. Pivot Chart - Slice and Dice the data to satisfy your analysis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The data you need for Part 2 is provided in the following Excel file. Be sure to use this file and do not enter anything manually from the case or use other sources for the data. Assignment Details...

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,...

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...

In this assignment, you will be assessed basedd on the following outcomes: GB 5 1 3 - 4 : Evaluate real - world situations and present solutions using statistical methods. PC - 6 . 1 : Incorporate...

GB513 Business Analytics B$ 2 2 QA b Content Discussions Assignments Quizzes Grades MoreTools v Help v Table of Contents > Unit 10 Unit 10 Assignment Unit 10 Assignment ~ ASSIGNMENT DETAILS In this...

In this assignment, you will be assessed basedd on the following outcomes: GB 5 1 3 - 4 : Evaluate real - world situations and present solutions using statistical methods. PC - 6 . 1 : Incorporate...

A second experiment involved only the group 2 subjects. In part A of the experiment, these 84 subjects were informed of the hazards (both fire and theft) of owning a valuable painting but were not...

Refer to Exercise 5-9. (1) Prepare a contribution margin income statement for Seton Company showing sales, variable costs, and fixed costs at the break-even point. (2) If the companys fixed costs...

Investors using the strategy of _ _ _ _ _ try to find stocks that are undervalued in the market.market timing investing for growth buying and holding value investing

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Know when firms should not offer service guarantees.

Be familiar with the seven groups of jaycustomers and understand how to manage them effectively.

Recognize the power of service guarantees.