cost anaylysis

[RUTVIK276]

hey can anyone help me solve this .it URGENT.there is a big table of medical cost analysis(includin BMI,AGE GROUP,REGION,CHARGES,SMOKER-YES/NO) and i have to find out about all this

1. Here we have four region, we want to know people belongs to which region having highest charges?

2. Through which statistical method we can identify if is there any affection on charges by smoking?(Name of Test)

3. Prepare a table which includes the detail of relation between gender and BMI by age group like- 15-30, 30 - 45, 45-60.

4. Based on above age groups, Define the age group Which having highest bmi?

5. Define the age group which having less charges?

6. Define the gender which paying more charges in southeast region?

 

[bobsan42]

I would think several pivot tables (and/or charts) will do what you need.

 

[DataBlake]

Hello and welcome to the board.
In order for someone to accurately assist you, you would need to provide examples of data using XL2BB or other method of sharing data.
Otherwise i'm pretty sure searching for already existing templates could also help you, just google things like "excel bmi index template" and whatever relevant phrases.

 

[AhoyNC]

A google search of contingency tables may be of help.