Forum Discussion

rutvik276's avatar
rutvik276
Copper Contributor
Mar 18, 2020
Solved

help please

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

9 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 18, 2020

    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.

    • rutvik276's avatar
      rutvik276
      Copper Contributor
      Mar 18, 2020

      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 questionsExcelExciting 

Resources