” STAT 200-010 写作、Python，c++程序 写作、 辅导Java编程语言Penn State UniversitySTAT 200-010Fall 2020Second Midterm ExamThursday October 29th, 2020 (8:25 AM 10:20 AM)Student Name:ID:Do not write Anything in this table; this is for grader use only!Question: 1(a) (5 Pts.) What is meant by a scatter plot?(b) (5 Pts.) Define the term Time Plot.(c) (10 Pts.) Use Excel to calculate the correlation factor of the following data:(d) (5 Pts.) Once you have calculated the correlation factor in c determine its Direction,Form, and Strength.3Question: 2You are given the following data set:X Y1.2 3.62.4 73.1 9.54.5 13.85.6 17.2This data set has a correlation factor = 0.9996. Do not use Excel in this question and showyour calculations in detail for full credit.(b) (5 Pts.) Calculate the standard deviations = .(c) (5 Pts.) Calculate the slope 1 = .(d) (5 Pts.) Calculate the y-intercept 0 = 1.(e) (5 Pts.) Write down the linear regression equation = 0 + 1 (you need to substitutenumerical values for 0 and 1).4Question: 3You are presented with the following data set:X Y Residuals1 5.22 10.63 16.14 22.35 27.8Do not use Excel for this question.(a) (15 Pts.) Given that the linear-regression equation for the data set above is = 5.69 0.67, Calculate (the predicted values of y according to the givenregression equation) and the residuals and fill them in the table above:(b) (5 Pts.) Define Extrapolation.(c) (5 Pts.) Use extrapolation to calculate (7).5Question: 4A factory produces 3 different products, product A, product B, and product C. The table belowshows the total Monthly cost (for 5 different months) sustained by the factory to produce a givencount of each product. Here are the data:Month Total FactoryCost (in $)Product A Product B Product C1 44439 515 541 7112 43936 929 692 8243 44464 800 710 7584 41533 979 675 6355 46343 1165 1147 901(a) (20 pts.) Using Excel Calculate the multiple-regression equation.(b) (5 Pts.) Once you have derived that equation, use it predict the total cost sustained by thefactory to produce 300, 400, and 500 counts of the A, B, and C products, respectively.如有需要，请加QQ：99515681 或邮箱：99515681@qq.com
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
