OBESITY SMOKER ALCOHOL - (heavy drinking more than once a month) 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...

60.1K

Verified Solution

Question

Basic Math

OBESITYSMOKERALCOHOL - (heavy drinking more than once amonth)Physical Inactivity (during leisure time)
%LCIUCI%LCIUCI%LCIUCI%LCIUCI
Q1 - least deprived18.2811.6927.4216.7511.1324.4415.349.15324.5747.5632.3263.28
Q221.314.9529.4121.1215.0428.8222.4110.6141.2940.2631.4349.76
Q32316.1831.6121.6215.9628.5925.3918.6733.5243.0635.8250.6
Q423.9916.5833.3826.1717.9736.4621.0711.8634.6250.7940.0261.48
Q5 - most deprived28.3621.5736.325.2516.5836.4921.215.727.9943.4835.6551.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!

Answer & Explanation Solved by verified expert
3.8 Ratings (416 Votes)
Put the data in the form shown in 2nd table select the data andselect insert    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students