The proportion of people working from home has undoubtedly risen since "Shelter in Place" orders were enacted. A fictional survey of 775 workers in 2020 found that 140 were working from home at least half the time, while in 2019, 30 of 825 workers were working from home at least half the time. Use the Excel spreadsheet below to create a 95% confidence interval for the difference in proportions of those working from home at least half the time.

AutoSave . Off) EX CI dp worksheet - Protected View . O Search Brandy Jackson Villarreal BJ X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X fc B D E H M N O P Q R S 2020 2019 sample size W # working from home 4 proportion working from home sample proportion difference Standard Error LO CO 0 confidence level 1 z - multiple 12 13 lower limit 14 upper limit 15 16 17 18 19 20 21 22 23 24 27 28 29 30 31 32 Sheet1 + - - + 100% Ready S X 1:42 PM Type here to search OF A NOW 11/20/2021