Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri
AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text v General Insert v Ex AY - O. Ex Delete v Paste BIU E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 X V fx B C D E F G H K 1 Job Title Yearly Average Salary 2 Accountants and Auditors 76,130 3 Actuaries 112,030 4 Acupuncturists and Healthcare Diagnosing or Treating Practitioners, All Other 80,390 Calculations/Values Formulas/Answers 5 Adhesive Bonding Machine Operators and Tenders 39,460 Mean 6 Administrative Law Judges, Adjudicators, and Hearing Officers 114,760 Standard Deviation Adult Basic Education, Adult Secondary Education, and English as a Second Language Instructors 58,860 8 Advertising and Promotions Managers 122,770 g Advertising Sales Agents 51,930 10 Aerospace Engineers 115,910 11 Agents and Business Managers of Artists, Performers, and Athletes 65,160 12 Agricultural and Food Science Technicians 43,580 13 Agricultural Equipment Operators 38,540 14 Agricultural Inspectors 59,80 15 Agricultural Sciences Teachers, Postsecondary 100,480 16 Agricultural Workers, All Other 37,230 17 Air Traffic Controllers 141,410 18 Aircraft Cargo Handling Supervisors 55,100 19 Aircraft Mechanics and Service Technicians 79,080 20 Aircraft Service Attendants and Transportation Workers, All Other 31,380 21 Animal Caretakers 30,980 22 Animal Control Workers 45,440 23 Animal Scientists 70,410 24 Animal Trainers 39,580 25 Anthropologists and Archeologists 74,440 26 Anthropology and Archeology Teachers, Postsecondary 84,040 27 Architects, Except Landscape and Naval 100,650 28 Architectural and Civil Drafters 57,170 29 Architectural and Engineering Managers 152,910 30 Architecture and Engineering Occupations 84,810 31 Archivists 47,820 32 Area, Ethnic, and Cultural Studies Teachers, Postsecondary 86,38 33 Art Directors 111,960 34 Art, Drama, and Music Teachers, Postsecondary 101,350 35 Artists and Related Workers, All Other 47,680 36 Arts, Design, Entertainment, Sports, and Media Occupations 57,790 37 Athletes and Sports Competitors 164,800 38 Athletic Trainers 53,660 39 Atmospheric and Space Scientists 87,970 40 Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary 87,730 41 Audio and Video Technician: 49,970 42 Audiologists 39,780 43 Audiovisual Equipment Installers and Repairers 52,730 44 Automotive Body and Related Repairers 51,390 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Ex Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 fix A B C D E F G H K 45 Automotive Glass Installers and Repairers 44,420 46 Automotive Service Technicians and Mechanics 46,780 47 Avionics Technicians 66,350 48 Bailiffs 52,770 49 Bakers 33,750 50 Barbers 42,630 51 Bicycle Repairers 33,250 52 Bill and Account Collectors 43,090 53 Billing and Posting Clerks 43,790 54 Bioengineers and Biomedical Engineers 110,240 55 Biological Science Teachers, Postsecondary 84,010 56 Biological Scientists, All Other 75,860 57 Biological Technicians 46,510 58 Boilermakers 35,170 59 Bookkeeping, Accounting, and Auditing Clerks 44,960 60 Brickmasons and Blockmasons 71,450 61 Bridge and Lock Tenders 52,060 62 Broadcast Announcers and Radio Disc Jockeys 33,510 63 Broadcast Technicians 40,130 64 Brokerage Clerks 56,660 65 Budget Analysts 81,27 66 Building and Grounds Cleaning and Maintenance Occupations 35,320 67 Bus and Truck Mechanics and Diesel Engine Specialists 53,700 68 Bus Drivers, Transit and Intercity 44,050 69 Business and Financial Operations Occupations 80 , 310 70 Business Teachers, Postsecondary 111,630 71 Butchers and Meat Cutters 35,790 2 Buyers and Purchasing Agents 71,920 73 Cabinetmakers and Bench Carpenters 42,620 74 Calibration Technologists and Technicians and Engineering Technologists and Technicians, Except Drafters, All Other 62,510 75 Camera and Photographic Equipment Repairers 46,030 Camera Operators, Television, Video, and Film 52,340 77 Captains, Mates, and Pilots of Water Vessels 76,860 78 Cardiovascular Technologists and Technicians $6,690 79 Career/Technical Education Teachers, Middle School 72,630 80 Career/Technical Education Teachers, Postsecondary 72,500 Career/Technical Education Teachers, Secondary School 64,540 82 Cargo and Freight Agents 56,250 83 Carpenters $4,990 84 Carpet Installers 60,830 85 Cartographers and Photogrammetrists 70,72 Cement Masons and Concrete Finishers 56,900 87 Chefs and Head Cooks 54,750 88 Chemical Engineers 107,610 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Delete v Paste BIU E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 + X V fx A B C D E F G H K 89 Chemical Equipment Operators and Tenders 44,960 90 Chemical Plant and System Operators 53,320 91 Chemical Technicians 54,230 92 Chemistry Teachers, Postsecondary 83,350 93 Chemists 87,960 94 Chief Executives 198,110 95 Child, Family, and School Social Workers 57,570 96 Chiropractors 93,540 97 Choreographers 47,290 98 Civil Engineering Technologists and Technicians 67,790 99 Civil Engineers 95,620 100 Claims Adjusters, Examiners, and Investigators 70,43 101 Cleaning, Washing, and Metal Pickling Equipment Operators and Tenders 36,990 102 Clergy 50,670 103 Clinical Laboratory Technologists and Technicians 59,840 104 Clinical, Counseling, and School Psychologists 85,560 105 Coaches and Scouts 42,850 106 Coating, Painting, and Spraying Machine Setters, Operators, and Tenders 43,680 107 Coil Winders, Tapers, and Finishers 37,000 108 Coin, Vending, and Amusement Machine Servicers and Repairers 46,130 109 Commercial and Industrial Designers 76,570 110 Commercial Pilots 111,690 111 Communications Equipment Operators, All Other 51,000 112 Communications Teachers, Postsecondary 59,300 113 Community and Social Service Occupations 52,300 114 Community and Social Service Specialists, All Other 48,220 115 Community Health Workers 44,260 116 Compensation and Benefits Managers 121,640 117 Compensation, Benefits, and Job Analysis Specialists 75,190 118 Compliance Officers 84,510 119 Computer and Information Research Scientists 133,340 120 Computer and Information Systems Managers 152,080 121 Computer and Mathematical Occupations 94,570 122 Computer Hardware Engineers 114,120 123 Computer Network Architects 126,050 124 Computer Network Support Specialists 71,410 125 Computer Numerically Controlled Tool Operators 47,370 126 Computer Numerically Controlled Tool Programmers 65,870 127 Computer Occupations, All Other 91,640 128 Computer Programmers 87,940 129 Computer Science Teachers, Postsecondary 83,010 130 Computer Systems Analysts 100,28 131 Computer User Support Specialists 57,960 132 Computer, Automated Teller, and Office Machine Repairers 44,290 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF 1 STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments AA ap Wrap Text v General Insert v Calibri (Body) * 11 Ex AY - O. Delete v Paste BIU E E Merg Wrap Text $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data F5 X V fx A B C D E F G H K 133 Concierges 32,790 134 Construction and Building Inspectors 74,430 135 Construction and Extraction Occupations 62,590 136 Construction Managers 97,310 137 Continuous Mining Machine Operators 68,830 138 Control and Valve Installers and Repairers, Except Mechanical Door 74,880 139 Conveyor Operators and Tenders 40,620 140 Cooks, All Other 35,030 141 Cooks, Institution and Cafeteria 35,160 142 Cooks, Restaurant 32,650 143 Cooling and Freezing Equipment Operators and Tenders 45,490 144 Correctional Officers and Jailers 54,360 145 Cost Estimators 69,640 146 Costume Attendants 51,060 147 Counselors, All Other 46,710 148 Counter and Rental Clerks 34,030 149 Couriers and Messengers 38,790 150 Court, Municipal, and License Clerks 47,860 151 Craft Artists 44,360 152 Crane and Tower Operators 57,420 153 Credit Analysts 80,47 154 Credit Authorizers, Checkers, and Clerks 48,630 155 Credit Counselors 49,760 156 Criminal Justice and Law Enforcement Teachers, Postsecondary 60,880 157 Crushing, Grinding, and Polishing Machine Setters, Operators, and Tenders 47,670 158 Curators 61,010 159 Customer Service Representatives 42,710 160 Cutting and Slicing Machine Setters, Operators, and Tenders 42,970 161 Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic 42,240 162 Data Entry Keyers 33,950 163 Data Scientists and Mathematical Science Occupations, All Other 98,260 164 Database Administrators and Architects 106,380 165 Dental Assistants 53,670 166 Dental Hygienists 76,410 167 Dental Laboratory Technicians 44,210 168 Dentists, All Other Specialists 195,210 169 Designers, All Other 68,260 170 Desktop Publishers 49,970 171 Detectives and Criminal Investigators 009'78 172 Diagnostic Medical Sonographers 83,360 173 Dietetic Technicians 39,68 174 Dietitians and Nutritionists 64,350 175 Directors, Religious Activities and Education 65,240 176 Dispatchers, Except Police, Fire, and Ambulance 49,970 Data Question 1 Question 2 Question 3 Question 4 Question 5 + + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ab Wrap Text General Insert v Ex AY - O. Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 B C D E F G H K 177 Drafters, All Other 57,300 178 Dredge Operators 72,550 179 Drilling and Boring Machine Tool Setters, Operators, and Tenders, Metal and Plastic 37,000 180 Driver/Sales Workers 31,320 181 Drywall and Ceiling Tile Installers 52,230 182 Earth Drillers, Except Oil and Gas; and Explosives Workers, Ordnance Handling Experts, and Blasters 54,590 183 Economists 102,090 184 Editors 64,150 185 Education Administrators, All Other 82,010 186 Education Administrators, Kindergarten through Secondary 111,070 187 Education Administrators, Postsecondary 110,58 188 Education and Childcare Administrators, Preschool and Daycare 62,810 189 Education Teachers, Postsecondary 74,570 190 Educational Instruction and Library Occupations 57,200 191 Educational Instruction and Library Workers, All Other 52,580 192 Educational, Guidance, and Career Counselors and Advisors 61,220 193 Electric Motor, Power Tool, and Related Repairers 46,760 194 Electrical and Electronic Engineering Technologists and Technicians 65,190 195 Electrical and Electronics Drafters 71,300 196 Electrical and Electronics Installers and Repairers, Transportation Equipment 70,100 197 Electrical and Electronics Repairers, Commercial and Industrial Equipment 66,820 198 Electrical and Electronics Repairers, Powerhouse, Substation, and Relay 98,380 199 Electrical Engineers 102,910 200 Electrical Power-Line Installers and Repairers 82,290 201 Electrical, Electronic, and Electromechanical Assemblers, Except Coil Winders, Tapers, and Finishers 38,230 202 Electricians 69,04 203 Electro-Mechanical and Mechatronics Technologists and Technicians 56,970 204 Electronic Equipment Installers and Repairers, Motor Vehicles 43,920 205 Electronics Engineers, Except Computer 103,230 206 Elementary School Teachers, Except Special Education 62,560 207 Elevator and Escalator Installers and Repairers 88,360 208 Emergency Management Directors 91,710 209 Emergency Medical Technicians and Paramedics 43,730 210 Engine and Other Machine Assemblers 47,040 211 Engineering Teachers, Postsecondary 109,600 212 Engineers, All Other 102,080 213 English Language and Literature Teachers, Postsecondary 70,290 214 Environmental Engineering Technologists and Technicians 54,190 215 Environmental Engineers 107,430 216 Environmental Science and Protection Technicians, Including Health 63,150 217 Environmental Science Teachers, Postsecondary 102,650 218 Environmental Scientists and Specialists, Including Health 78,260 219 Epidemiologists 76,270 220 Excavating and Loading Machine and Dragline Operators, Surface Mining 56,370 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ab Wrap Text General Insert v Ex AY - O. Ex Delete v Paste BIU E E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 X V fx B C D E F G H K 221 Executive Secretaries and Executive Administrative Assistants 62,490 222 Exercise Physiologists 59,140 223 Exercise Trainers and Group Fitness Instructors 46,430 224 Extruding and Drawing Machine Setters, Operators, and Tenders, Metal and Plastic 44,090 225 Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders 41,980 226 Fabric and Apparel Patternmakers 56,16 227 Farm and Home Management Educators 50,170 228 Farm Equipment Mechanics and Service Technicians 49,250 229 Farmers, Ranchers, and Other Agricultural Managers 99,890 230 Farming, Fishing, and Forestry Occupations 39,060 231 Farmworkers and Laborers, Crop, Nursery, and Greenhouse 35,320 232 Fashion Designers 73,170 233 Fence Erectors 38,760 234 Fiberglass Laminators and Fabricators 38,460 235 File Clerks 35,540 236 Film and Video Editors 74,230 237 Financial and Investment Analysts, Financial Risk Specialists, and Financial Specialists, All Other 93,730 238 Financial Clerks, All Other 45,060 239 Financial Examiners 92,590 240 Financial Managers 142,210 241 Fine Artists, Including Painters, Sculptors, and Illustrators 57,860 242 Fire Inspectors and Investigator 76,020 243 Firefighters 41,180 244 Flight Attendants 54,320 245 Floor Layers, Except Carpet, Wood, and Hard Tiles 46,190 246 Food and Tobacco Roasting, Baking, and Drying Machine Operators and Tenders 38,94 247 Food Batchmakers 36,700 248 Food Cooking Machine Operators and Tenders 39,870 249 Food Preparation Workers 31,330 250 Food Processing Workers, All Other 32,940 251 Food Scientists and Technologists 79,83 252 Food Service Managers 62,820 253 Foreign Language and Literature Teachers, Postsecondary 72,490 254 Forensic Science Technicians 70,440 255 Forest and Conservation Technicians 46,340 256 Forest and Conservation Workers 43,440 257 Foresters 63,190 258 Forging Machine Setters, Operators, and Tenders, Metal and Plastic 42,080 259 Foundry Mold and Coremakers 42,370 260 Fundraisers 64,540 261 Funeral Attendants 32,350 262 Funeral Home Managers 111,710 263 Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders 45,550 264 Furniture Finishers 40,230 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Ex Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 fx A B C D E F G H K 265 Gas Plant Operators 74,140 266 General and Operations Managers 120,190 267 Genetic Counselors 83,330 268 Geographers 71,360 269 Geography Teachers, Postsecondary 81,340 270 Geological and Hydrologic Technicians 59,74 271 Geoscientists, Except Hydrologists and Geographers 83,570 272 Glaziers 56,910 273 Graders and Sorters, Agricultural Products 31,190 274 Graphic Designers 54,360 275 Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic 10,600 276 Grounds Maintenance Workers, All Other 45,990 277 Hairdressers, Hairstylists, and Cosmetologists 33,510 278 Hazardous Materials Removal Workers 59,830 279 Health and Safety Engineers, Except Mining Safety Engineers and Inspectors 95,540 280 Health Education Specialists 50,610 281 Health Information Technologists, Medical Registrars, Surgical Assistants, and Healthcare Practitioners and Technical Workers, Al 77,450 282 Healthcare Practitioners and Technical Occupations 91,990 283 Healthcare Social Workers 57,960 284 Healthcare Support Occupations 33,320 285 Healthcare Support Workers, All Other 40,400 286 Hearing Aid Specialists 51,440 287 Heat Treating Equipment Setters, Operators, and Tenders, Metal and Plastic 38,960 288 Heating, Air Conditioning, and Refrigeration Mechanics and Installers 62,820 289 Heavy and Tractor-Trailer Truck Drivers 51,040 290 Helpers-Brickmasons, Blockmasons, Stonemasons, and Tile and Marble Setters 58,36 291 Helpers-Carpenter 36,640 292 Helpers-Electricians 43,890 293 Helpers-Installation, Maintenance, and Repair Workers 36,730 294 Helpers-Painters, Paperhangers, Plasterers, and Stucco Masons 42,660 295 Helpers-Pipelayers, Plumbers, Pipefitters, and Steamfitters 38,81 296 Highway Maintenance Workers 53,640 297 History Teachers, Postsecondary 79,230 298 Hoist and Winch Operators 78,860 299 Home Appliance Repairers 44,090 300 Human Resources Assistants, Except Payroll and Timekeeping 45,490 301 Human Resources Managers 128,440 302 Human Resources Specialists 70,010 303 Hydrologist 80,880 304 Industrial Engineering Technologists and Technicians 57,080 305 Industrial Engineers 94,40 306 Industrial Machinery Mechanics 60,900 307 Industrial Production Managers 117,850 308 Industrial Truck and Tractor Operators 45,960 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ab Wrap Text General Insert v Ex AY - O. Ex Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 fix A B C D E F G H K 309 Information and Record Clerks, All Other 48,010 310 Information Security Analysts 103,750 311 Inspectors, Testers, Sorters, Samplers, and Weighers 45,680 312 Installation, Maintenance, and Repair Occupations 54,700 313 Installation, Maintenance, and Repair Workers, All Other 48,110 314 Instructional Coordinators 76,820 315 Insulation Workers, Floor, Ceiling, and Wall 48,990 316 Insulation Workers, Mechanical 75,970 317 Insurance Claims and Policy Processing Clerks 47,680 318 Insurance Sales Agents 78,220 319 Insurance Underwriters 83,16 320 Interior Designers 62,480 321 Interpreters and Translators 52,110 322 Interviewers, Except Eligibility and Loan 39,660 323 Jewelers and Precious Stone and Metal Workers 38,490 324 Judges, Magistrate Judges, and Magistrates 147,75 325 Judicial Law Clerks 58,710 326 Kindergarten Teachers, Except Special Education 63,010 327 Labor Relations Specialists 73,310 328 Laborers and Freight, Stock, and Material Movers, Hand 37,70 329 Landscape Architects 74,960 330 Landscaping and Groundskeeping Workers 36,720 331 Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic 46,490 332 Law Teachers, Postsecondary 137,280 333 Lawyers 131,460 334 Layout Workers, Metal and Plastic 46,640 335 Legal Occupations 103,830 336 Legal Secretaries and Administrative Assistants 57,350 337 Legal Support Workers, All Other 72,470 338 Legislators 35,750 339 Librarians and Media Collections Specialists 64,70 340 Library Assistants, Clerical 33,130 341 Library Science Teachers, Postsecondary 72,330 342 Library Technicians 46,020 343 Licensed Practical and Licensed Vocational Nurses 49,840 344 Life, Physical, and Social Science Occupations 83,02 345 Light Truck Drivers 42,810 346 Lighting Technicians and Media and Communication Equipment Workers, All Other 72,990 347 Loan Interviewers and Clerks 44,650 348 Loan Officers 79,740 349 Locksmiths and Safe Repairers 50,06 350 Locomotive Engineers 77,170 351 Lodging Managers 62,800 352 Logging Equipment Operators 43,890 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text v General Insert v Ex AY - O. Delete v Paste BIU E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data F5 4 X V fx A B C D E F G H K 353 Logisticians 77,650 354 Machine Feeders and Offbearers 36,400 355 Machinists 52,710 356 Magnetic Resonance Imaging Technologists 80,230 357 Mail Clerks and Mail Machine Operators, Except Postal Service 33,890 358 Maintenance and Repair Workers, General 49,180 359 Maintenance Workers, Machinery 52,220 360 Management Analysts 98,600 361 Management Occupations 124,020 362 Market Research Analysts and Marketing Specialists 78,600 363 Marketing Managers 150,820 364 Marriage and Family Therapists 63,700 365 Massage Therapists 53,060 366 Material Moving Workers, All Other 45,920 367 Materials Engineers 101,220 368 Materials Scientist 96,570 369 Mathematical Science Teachers, Postsecondary 82,750 370 Meat, Poultry, and Fish Cutters and Trimmers 33,380 371 Mechanical Door Repairers 43,860 372 Mechanical Drafters 63,090 373 Mechanical Engineering Technologists and Technicians 63,400 374 Mechanical Engineers 88,340 375 Media and Communication Workers, All Other 58,730 376 Medical and Health Services Managers 111,360 377 Medical Appliance Technicians 52,800 378 Medical Assistants 43,090 379 Metal-Refining Furnace Operators and Tenders 53,970 380 Meter Readers, Utilities 59,720 381 Microbiologists 76,660 382 Middle School Teachers, Except Special and Career/Technical Education 63,670 383 Milling and Planing Machine Setters, Operators, and Tenders, Metal and Plastic 48,460 384 Millwrights 64,340 385 Motorcycle Mechanics 45,270 386 Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic 42,610 387 Museum Technicians and Conservators 39,910 388 Music Directors and Composers 19,120 389 Musical Instrument Repairers and Tuners 41,510 390 Natural Sciences Manager 141,930 391 Network and Computer Systems Administrators 86 ,860 392 New Accounts Clerks 43,290 393 News Analysts, Reporters, and Journalists 64,260 394 Nuclear Engineers 119,750 395 Nuclear Medicine Technologists 87,530 396 Nurse Midwives 123,600 Data Question 1 Question 2 Question 3 Question 4 Question 5 + + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text v General Insert v Ex AY - O. Delete v Paste BIU E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 A B C D E F G H K 397 Nurse Practitioners 118,900 398 Nursing Assistants 36,040 399 Nursing Instructors and Teachers, Postsecondary 72,590 400 Optometrist 137,530 401 Order Clerks 38,660 402 Orderlies 39,20 403 Orthotists and Prosthetists 79,420 404 Outdoor Power Equipment and Other Small Engine Mechanics 42,030 405 Packaging and Filling Machine Operators and Tenders 38,030 406 Painters, Construction and Maintenance 55,490 407 Painting, Coating, and Decorating Workers 41,780 408 Paper Goods Machine Setters, Operators, and Tenders DO0'01 409 Paralegals and Legal Assistants 58,270 410 Parking Enforcement Workers 40,940 411 Parts Salespersons 38,460 412 Passenger Vehicle Drivers, Except Bus Drivers, Transit and Intercity 38,540 413 Patternmakers, Metal and Plastic 59,470 414 Paving, Surfacing, and Tamping Equipment Operators 56,830 415 Payroll and Timekeeping Clerks 52,640 416 Personal Care and Service Occupations 33,490 417 Personal Financial Advisors 153,830 418 Personal Service Managers, All Other; Entertainment and Recreation Managers, Except Gambling; and Managers, All Other 128,080 419 Pest Control Workers 40,400 420 Pesticide Handlers, Sprayers, and Applicators, Vegetation 35,810 421 Petroleum Pump System Operators, Refinery Operators, and Gaugers 66,730 422 Pharmacists 130,690 423 Pharmacy Aides 31,260 424 Pharmacy Technicians 39,770 425 Philosophy and Religion Teachers, Postsecondary 76,750 426 Phlebotomists 40,150 427 Photographers 60,63 428 Physical Therapist Aides 38,250 429 Physical Therapist Assistants 57,920 430 Physical Therapists 86,020 431 Physician Assistants 122,280 432 Physicists 145,770 433 Physics Teachers, Postsecondary 99,590 434 Pile Driver Operators 72,200 435 Pipelayer 76,390 436 Plant and System Operators, All Other 60,460 437 Plasterers and Stucco Masons 73,340 438 Plumbers, Pipefitters, and Steamfitters 76,080 439 Podiatrists 168,430 440 Police and Sheriff's Patrol Officers 74,370 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 fx A B C D E F G H K 441 Political Science Teachers, Postsecondary 91,630 442 Postal Service Clerks 50,830 443 Postal Service Mail Carriers 52,520 444 Postal Service Mail Sorters, Processors, and Processing Machine Operators 49,720 445 Postmasters and Mail Superintendents 77,100 446 Postsecondary Teachers, All Other 56,050 447 Pourers and Casters, Metal 40,590 448 Power Distributors and Dispatchers 84,68 449 Power Plant Operators 89,580 450 Precision Instrument and Equipment Repairers, All Other 65,650 451 Prepress Technicians and Workers 51,170 452 Preschool Teachers, Except Special Education 40,280 453 Print Binding and Finishing Workers 40,960 454 Printing Press Operators 45,500 455 Probation Officers and Correctional Treatment Specialists 70,070 456 Procurement Clerks 44,970 457 Producers and Directors 73,100 458 Production Occupations 43,430 459 Production Workers, All Other 37,180 460 Production, Planning, and Expediting Clerks 53,440 461 Project Management Specialists and Business Operations Specialists, All Other 76,740 462 Proofreaders and Copy Markers 45,930 463 Property Appraisers and Assessors 66,79 464 Property, Real Estate, and Community Association Managers 74,580 465 Protective Service Occupations 55,170 466 Psychiatric Aides 42,830 467 Psychologists, All Other 94,360 468 Psychology Teachers, Postsecondary 87,560 469 Public Relations and Fundraising Managers 118,470 470 Public Relations Specialists 67,860 471 Public Safety Telecommunicators 57,050 472 Pump Operators, Except Wellhead Pumpers 50,320 473 Purchasing Manager 127,070 474 Radiation Therapists 85,090 475 Radio, Cellular, and Tower Equipment Installers and Repairers 70,570 476 Radiologic Technologists and Technicians 70,570 477 Rail Car Repairers 63,170 478 Rail Yard Engineers, Dinkey Operators, and Hostlers 62,730 479 Railroad Brake, Signal, and Switch Operators and Locomotive Firers 57,410 480 Railroad Conductors and Yardmasters 67,060 481 Rail-Track Laying and Maintenance Equipment Operators 54,340 482 Real Estate Brokers 58,690 483 Real Estate Sales Agents 46,760 484 Receptionists and Information Clerks 32,880 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Ex Delete v Paste BIU E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 X V fx A B C D E F G H K 485 Recreation and Fitness Studies Teachers, Postsecondary 67,050 486 Recreational Therapists 49,630 487 Recreational Vehicle Service Technicians 64,360 488 Refuse and Recyclable Material Collectors 40,230 489 Registered Nurse 80,960 490 Rehabilitation Counselors 42,00 491 Reinforcing Iron and Rebar Workers 71,620 492 Religious Workers, All Other 54,750 493 Reservation and Transportation Ticket Agents and Travel Clerks 51,780 494 Residential Advisors 41,090 495 Respiratory Therapists 69,83 496 Riggers 67,200 497 Rock Splitters, Quarry 40,120 498 Rolling Machine Setters, Operators, and Tenders, Metal and Plastic 43,610 499 Roofers 58,860 500 Sales and Related Occupations 48,16 501 Sales and Related Workers, All Other 37,900 502 Sales Engineers 97,960 503 Sales Managers 136,490 504 Sales Representatives of Services, Except Advertising, Insurance, Financial Services, and Travel 71,790 505 Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products 80,21 506 Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products 91,120 507 Sawing Machine Setters, Operators, and Tenders, Wood 37,010 508 School Bus Monitors and Protective Service Workers, All Other 37,850 509 Secondary School Teachers, Except Special and Career/Technical Education 64,540 510 Secretaries and Administrative Assistants, Except Legal, Medical, and Executive 42,560 511 Securities, Commodities, and Financial Services Sales Agents 104,300 512 Security and Fire Alarm Systems Installers 59,760 513 Security Guards 38,800 514 Self-Enrichment Teachers 43,400 515 Separating, Filtering, Clarifying, Precipitating, and Still Machine Setters, Operators, and Tenders 45,05 516 Septic Tank Servicers and Sewer Pipe Cleaners 54,710 517 Service Unit Operators, Oil and Gas 58,400 518 Set and Exhibit Designers 56,850 519 Sewing Machine Operators 34,260 520 Sheet Metal Workers 67,27 521 Shipping, Receiving, and Inventory Clerks 39,980 522 Shoe and Leather Workers and Repairers 36,800 523 Signal and Track Switch Repairers 70,820 524 Skincare Specialists 43,120 525 Slaughterers and Meat Packers 32,83 526 Social and Community Service Managers 78,960 527 Social and Human Service Assistants 38,490 528 Social Science Research Assistants 49,770 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text General Insert v Ex AY - O. Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data F5 4 X VS. A B C D E F G H K 529 Social Sciences Teachers, Postsecondary, All Other 87,340 530 Social Scientists and Related Workers, All Other 94,680 531 Social Work Teachers, Postsecondary 70,300 532 Social Workers, All Other 63,910 533 Sociologists 59,400 534 Sociology Teachers, Postsecondary 79,39 635 Software Developers and Software Quality Assurance Analysts and Testers 108,060 536 Soil and Plant Scientists 68,240 537 Sound Engineering Technicians 56,680 538 Special Education Teachers, All Other 65,920 539 Special Education Teachers, Kindergarten and Elementary School 59,18 540 Special Education Teachers, Middle School 64,820 541 Special Education Teachers, Preschool 63,590 542 Special Education Teachers, Secondary School 64,490 543 Special Effects Artists and Animators DOE'49 544 Speech-Language Pathologists 75,680 545 Stationary Engineers and Boiler Operators 63,440 546 Statistical Assistants 50,73 547 Statisticians 88 ,620 548 Stockers and Order Fillers 33,210 549 Stonemasons 43,230 550 Structural Iron and Steel Workers 58,290 551 Structural Metal Fabricators and Fitters 46,210 552 Substance Abuse, Behavioral Disorder, and Mental Health Counselors 53,450 553 Substitute Teachers, Short-Term 36,550 554 Surgical Technologists 61,300 $55 Survey Researchers 69,020 556 Surveying and Mapping Technicians 58,410 $57 Surveyors 66,020 558 Switchboard Operators, Including Answering Service 37,580 559 Tailors, Dressmakers, and Custom Sewers 38,380 560 Tank Car, Truck, and Ship Loaders 45,140 561 Tapers 65,290 562 Tax Examiners and Collectors, and Revenue Agents 67,110 563 Tax Preparers 51,540 564 Teaching Assistants, Except Postsecondary 33,510 565 Teaching Assistants, Postsecondary 39,070 566 Technical Writers 70,480 567 Telecommunications Equipment Installers and Repairers, Except Line Installers 52,150 568 Telecommunications Line Installers and Repairers 52,450 569 Telemarketers 37,910 570 Tellers 33,500 571 Textile Knitting and Weaving Machine Setters, Operators, and Tenders 34,930 572 Therapists, All Other 57,900 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) * 11 AA ab Wrap Text v General Ex AY- O. Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data F5 A B C D E F G H K 573 Title Examiners, Abstractors, and Searchers 53,710 574 Tool and Die Makers 58,470 575 Tool Grinders, Filers, and Sharpeners 44,820 576 Training and Development Managers 119,920 577 Training and Development Specialists 73,78 578 Transit and Railroad Police 74,270 579 Transportation and Material Moving Occupations 42,230 580 Transportation Inspectors 85,040 581 Transportation, Storage, and Distribution Managers 107,750 582 Travel Agents 48,300 583 Tutors and Teachers and Instructors, All Other 42,710 584 Umpires, Referees, and Other Sports Officials 42,220 585 Underground Mining Machine Operators and Extraction Workers, All Other 62,920 586 Upholsterers 42,680 587 Urban and Regional Planners 82,290 588 Veterinarians 92,800 589 Veterinary Technologists and Technicians 38,120 590 Water and Wastewater Treatment Plant and System Operators 59,400 591 Web Developers and Digital Interface Designer 82,500 592 Weighers, Measurers, Checkers, and Samplers, Recordkeeping 40,160 593 Welders, Cutters, Solderers, and Brazers 48,070 594 Welding, Soldering, and Brazing Machine Setters, Operators, and Tenders 48,760 595 Wind Turbine Service Technicians 61,880 596 Woodworkers, All Other 31,470 597 Woodworking Machine Setters, Operators, and Tenders, Except Sawing 36,95 598 Word Processors and Typists 46,110 599 Writers and Authors 64,640 600 Zoologists and Wildlife Biologists 62,370 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%STA 3215 Deliverable 3 - Confidence Intervals Q AutoSave . OFF Page Layout Formulas Data Review View Tell me Share Comments Home Insert Draw Insert v Calibri (Body) * 11 AA ab Wrap Text v General Ex AY - O. Ex Delete v $ ~ % " Sort & Find & Sensitivity E Conditional Format Paste BIU BY OvAv Merge & Center v Cell Analyze Formatting as Table Styles Format v Filter Select Data Q16 41 X V fx AA C D E F G H J K L M N 0 P Q R S T U V W X Z 1. Discuss the importance of constructing confidence intervals for the population mean by answering these questions. a. What are confidence intervals? b. What is a point estimate? 10 11 12 13 c. What is the best point estimate for the population mean? Explain. 14 15 16 17 d. Why do we need confidence intervals? 18 19 20 21 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments AA" ab Wrap Text General Insert v Calibri (Body) * 11 =1 Ex AY- O. Ex Delete v Paste BIU E EEE Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data N4 41 X V fx E F G H K M N Q R S T U V W X 2. Using the data from the 'Data' tab in this workbook, construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and o is unknown. Include a statement that correctly interprets the Calculations/Values Formulas/Answers confidence interval in context of the scenario. Mean Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and paste the values. Instead, use Standard Deviation cell referencing to use the unrounded values. Calculate all of the values needed to create this confidence interval to the right. Critical Value Below, include a breakdown of the steps, include formulas, and correctly interpret the solution in context of the scenario with Margin of Error 10 the correct units. Lower Limit 11 Upper Limit 12 13 14 15 16 17 18 Data Question 1 Question 2 Question 3 Question 4 Question 5 + + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA" General Insert v =1 ab Wrap Text v Ex AY - O. 4 Ex Delete v Paste BIUVE E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v v Filter Select Data N4 4 X V fx E G H M N P Q R S T U v W 3. Using the data from the 'Data' tab in this workbook, construct a 99% confidence interval for the population mean. Assume NAWNE that your data is normally distributed and o is unknown. Include a statement that correctly interprets the confidence interval Calculations/Values Formulas/Answers in context of the scenario. Mean Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and poste the values. Instead, use Standard Deviation cell referencing to use the unrounded values Calculate all of the values needed to create this confidence interval to the right. Critical Value Below, include a breakdown of the steps, include formulas, and correctly interpret the solution in context of the scenario with the Margin of Error 10 correct units. Lower Limit 11 Upper Limit 12 13 14 15 16 17 18 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%Q AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Page Layout Formulas View Share Comments Home Insert Draw Data Review Tell me Insert v Calibri (Body) * 11 AA" ab Wrap Text General Ex AY - O. 4 Ex Delete v Sort & Find & Analyze Sensitivity Paste BIU BY OvAv E Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Styles Format v v Filter Select Data 019 x v fx D E G H K L M N 0 P Q R S T U v w X Z AA 4. Compare your answers for Question 2 and 3. Notice that the 99% confidence interval is wider. a. What is the advantage of using a wider confidence interval? LD C 10 b. Why would you not always use the 99% confidence interval? Explain with an example. 11 12 13 14 15 16 17 18 19 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%AutoSave . OFF STA 3215 Deliverable 3 - Confidence Intervals Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) * 11 AA = a Wrap Text v General Ex AY - O. Ex Delete v E Sort & Find & Analyze Sensitivity Paste BIU BY OvAv E Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Styles Format v v Filter Select Data N6 4 x v fx D E F G H 1 J K L M N 0 P Q R S T U v w X Z AA 5. We want to estimate the mean salary in Minnesota. a. How many jobs must be randomly selected for their respective mean salaries if we want 99% confidence that the sample mean is within $2000 of the population mean. Assume that a previous sample provided a population standard deviation of $18,000 V (z) Show your calculations using Excel functions in the area to the right of this text box and answer the problem with explanations sigma below. 10 11 12 13 14 b. Is the current sample size of 599 in the data set in our Excel workbook large enough? Explain. 15 16 17 18 19 20 Data Question 1 Question 2 Question 3 Question 4 Question 5 + - + 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started