help please

[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?

[#2]

Hi @rutvik276 

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.

[#3]

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

[#4]

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 

[#5]

Hi @rutvik276 

Share the sample data with your records

Regards, Faraz Shaikh 

[#6]

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

[#7]

Hi @rutvik276 

While replying the post simply attached the file 

Regards, Faraz Shaikh

 

[#8]

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

[#9 · Accepted solution]

Hi @rutvik276 

Please see the attached file with all your question 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.

[#10 · Accepted solution]

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

[#11]

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

[#12]

@rutvik276 wonderful.. I am happy to hear you solved it by yourself .. :)

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.

[#13]

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