| OBESITY | | | SMOKER | | | ALCOHOL - (heavy drinking more than once amonth) | Physical Inactivity (during leisure time) |
| % | LCI | UCI | % | LCI | UCI | % | LCI | UCI | % | LCI | UCI |
| Q1 - least deprived | 18.28 | 11.69 | 27.42 | 16.75 | 11.13 | 24.44 | 15.34 | 9.153 | 24.57 | 47.56 | 32.32 | 63.28 |
| Q2 | 21.3 | 14.95 | 29.41 | 21.12 | 15.04 | 28.82 | 22.41 | 10.61 | 41.29 | 40.26 | 31.43 | 49.76 |
| Q3 | 23 | 16.18 | 31.61 | 21.62 | 15.96 | 28.59 | 25.39 | 18.67 | 33.52 | 43.06 | 35.82 | 50.6 |
| Q4 | 23.99 | 16.58 | 33.38 | 26.17 | 17.97 | 36.46 | 21.07 | 11.86 | 34.62 | 50.79 | 40.02 | 61.48 |
| Q5 - most deprived | 28.36 | 21.57 | 36.3 | 25.25 | 16.58 | 36.49 | 21.2 | 15.7 | 27.99 | 43.48 | 35.65 | 51.65 |
I have these numbers and am asked to create a bar chart witherror bars in excel for the confidence intervals and am only giventhis data... how do I make this bar char with confidence intervals! The percentages are what is to be graphed, it is assumed they arethe mean. THE DATA IS IN A COPIABLE FORM. I COPIED AND PASTEDSTRAIGHT FROM HERE INTO EXCEL!
