EA 3 ANSWER FORM

docx

School

Purdue University *

*We aren’t endorsed by this school

Course

23500

Subject

Statistics

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by EarlGrouse3016

STAT 30301 – EXCEL ACTIVITY 3: ANSWER FORM 20 points Enter your answers & Excel outputs by their problem numbers. Save completed form as a pdf. Submit completed pdf of THIS FORM to your Brightspace STAT 30301 Merge Course for credit. 1. Type your answers below. (2 points) Sector 6730 is a manufacturing sector that is enrolled in an emission program 2. Paste your Excel output below. (2 points) Count of Emission Program Column Labels Row Labels Agriculture Energ y Manufacturin g Minin g Grand Total No 6 10 11 30 57 Yes 18 17 24 47 106 Grand Total 24 27 35 77 163 3. Type your answer below. (1 point) Agricultural, Energy, Manufacturing, Mining 4. Type your answer below. (1 point) No, Yes 5. Type your answer below. (2 points) P(Agricultural)= 24/163= 0.1472, marginal 6. Type your answer below. (2 points) P(Agricultural and Yes)=18/163= 0.1104, joint 7. Type your answer below. (2 points) P(No)= 57/163 = 0.3497, marginal GO TO NEXT PAGE FOR #8 - #12

8. Type your answer below. (2 points) P(Yes|Agricultural) = 18/24= 0.75, conditional 9. Type your answer below. (2 points) P(Agricultural|Yes) = 18/106=0.1698, conditional 10. Type your answer below. (2 points) P(Manufacturing^C)= 1-35/163=0.7853 1-35/163 11. Type your answer below. (2 points) No, because P(Agricultural|Yes)=0.1698 does not equal P(Agricutural)=0.1472 and for numbers to be independent those 2 numbers must be the same 12. SAVE THIS ANSWER FORM D ocument AS A PDF ; any other file type will receive AT MOST 75% credit for the assignment. Upload your SINGLE pdf file to the Excel Activity 3 Assignment in the Brightspace Merge course.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version