SOLVED

Highlighted
Occasional Contributor

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?
9 Replies
Highlighted

The best solution is to make the PivotTable that can answer all your point.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Highlighted

i make a pivot table then how to do sir.i am a beginner in excel.i know to add different categories but how will that answer my questions@Faraz Shaikh

Highlighted

Share the sample data with your records

Regards, Faraz Shaikh

Highlighted

i am sorry but i dont know how to send excel file here@Faraz Shaikh

Highlighted

While replying the post simply attached the file

Regards, Faraz Shaikh

Highlighted

oh sorry for being so stupid.here it is @Faraz Shaikh

Highlighted
Best Response confirmed by rutvik276 (Occasional Contributor)
Solution

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Highlighted

@Faraz Shaikh Great though its late.I aready have done it as u suggested me pivot table  earlier.Thank you so much for solving in so detail and using your time.

Highlighted