AutoSave On . O X Angelachristmas_Module3Lesson1-2Home... - Saved . Search Santablk Christmas File Home Insert Page Layout Formulas Data Review View Help Share Comments 11 YA* A ab Wrap Text General AY O LO Calibri Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU E = Merge & Center ~ $ ~ % " Formatting * Table Styles Filter * Select v Data Font Styles Cells Editing Analysis Clipboard Alignment Number J19 X V fix C D E F G H K L M N O P Q R S A B Meal Price Problem 3: Restaurant ratings Quality 1 2 3 Total The data presented in the table is the result of a survey of 300 restaurants 1 42 39 3 84 Ratings on price are from 1 (least) to 3 (most) expensive. Ratings on quality follow the same 1 to 3 pattern (least to most). 2 03 54 150 a.) Copy this table an create a bivariate probability distribution for quality and meal price. A 2 33 2 3 15 48 66 Quality Rating In b.) Compute the expected value and variance for quality rating (x) Meal Price Total 78 6 117 105 300 c.) Compute the expected value and variance for meal price. (y) Expected Enter your search term Variance Value 00 d.) Compute the covariance of x & y Covariance 9 Correlation 10 e.) Compute the correlation coefficient of x & y 11 12 13 14 15 16 17 18 6 of 24 - Clipboard Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 + Item not Collected: Delete items to increase available space Ready 11:53 AM Type here to search O X 67'F Cloudy ~ x10/21/2021