A consumer affairs group examine relationship between tv viewing (in hours/week), readership (in minutes/day),the network watched (ABC,NBC,CBS). sample results given in excel.

A. Develop regression model predict interest in public affairs using tv viewing, reading, network as independent variables. What is regression equation

B. What proportion total variation in the interest in public affairs by 3 factors in regression model

c. Use regression model above, give regression equation relate interest in tv viewing, reading for viewers watched NBC network news frequently

D. Use regression above, 95% C.I. for the interest in public affairs of individual viewer view 45 hours/week,

Reads 25 minutes/day and watch NBC network most frequently.

E. Prediction in part D reliable? Why

Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Arial v 10 A" A " ab v Conditional Formatting v Format as Table Paste BI U V V DVAv Number Cells Editing Analyze i Cell Styles v Data 114 X V fx A B C D E F G H I J K L M N O P Q R Interest TV Viewing Reading Network 80 25 42 CBS 47 22 ABC 93 7 80 NBC 46 37 28 ABC 71 13 16 CBS 98 5 70 CBS ONJOO VOU A WN 75 20 20 CBS 56 27 25 NBC 84 8 32 ABC 75 14 18 NBC 88 43 ABC 11 17 ABC 14 15 36 37 38 40 41 42 43 Q1-Edison Q2-TV News Q4-Six-pack Q5-Statistics Q6-Facebook + Ready Accessibility: Good to go + 100%