Question

Based on this data, how many times would a student need to visit the website (hits) to average 85 on their quizzes? Hits (X) Average (Y) 123 52.5 926 67 141 53 615 911 54.5 65.5 787 61 608 561 552 548 908 70 70 83

Answer 1

Sign in S FILE HOME INSERT PAGE LAYOUT AX Cut Calibri 11 Ee Copy Paste Format Painter BIU - F Clipboard Font FORMULAS DATA A A == A 3 Bookl - Excel (Product Activation Failed) REVIEW VIEW Wrap Text General D Merge & Center - $ % 8. Conditional Format as Formatting Table Alignment Number Styles X Insert Delete Format Cell Styles AutoSum" AY # Fill Sort & Find & Clear Filter - Select Editing Cells K19 C D E F G H I J K L M N O P B 1 Average Hits 52.5 Format Shape Hits 67 53 y = 18.636x - 652.96 R = 0.4743 FILL 54.5 LINE 911 787 HITS Hits RRR 561 ......... Linear (Hits) 552 548 908 1014 103 542 90 20 80 100 40 60 AVERAGE 72.5 Sheet1 + READY !!! - + 100%

From regressiin analysis we found equation that hits=18.636*average-652.96

So for 85 average we can find hits = 930

Which is near about 900 from available option

So 900 is right answer