[solved]-Using The 51 Pairs Of Data Number Of Pages And Cost Of Textbook In The Worksheet Please Answer All Of The Following Which Variable Should Be The Dependent Variable And Which Should Be The In 07595

Using the 51 pairs of data (number of pages and cost of textbook ) in the Worksheet,please answer all of the following:Which variable should be the dependent variable and whichshould be the independent variable ? Why?In the excel worksheet, graph your textbook variables “pages”vs. “cost” by using the Insert>RecommendedCharts>Scatterplot option to scatterplot the 51 points on thegraph. Label both your scatterplot axes and Title withwords. Select a trendline for your regression line ( line ofbest fit ). Write the linear equation for this data by using theexcel LINEST function ( to obtain your y-intercept and slope). Obtain your correlation coefficient, r, ( use the excelPEARSON function ) and your correlation coefficient ofdetermination, r2. Is the correlation weak or strong ? Why ? Using your regression equation, predict the costs of a 100page, 400 page and 800 page textbook?Remove three ( 3 ) potential outliers ( data points ) if thesample standard deviation, s, = 46.97, using 2x your samplestandard deviation as your threshold of rejectionUse either a graphical or numerical process ( show your work )to justify the exclusion of these 3 outliers from your data.After removing these three outliers, re-calculate your newregression line equation and ( improved ? ) correlationcoefficient, r. ( note that your new n will equal 48)Slope for xStandard error for xR2F statisticRegression sum of squaresInterceptStandard error for interceptStandard error for y estimateDegrees of freedomResidual sum of squares number of pages cost of text book125$12.43175$23.49235$44.16267$50.92350$63.4590$15.62114$21.24158$35.68209$35.75350$41.26450$112.89500$125.87289$67.55824$186.34750$312.25350$175.33247$88.52167$25.89430$127.56268$220.10378$175.68647$225.89341$150.00430$190.23175$25.00243$88.69648$135.24186$46.72257$99.64235$87.68783$124.21358$107.28450$247.99386$213.69280$138.76118$45.87550$190.24578$175.89530$167.00457$137.89675$228.69730$210.48879$278.00430$122.00486$175.38700$195.32803$263.24684$163.25758$275.36784$268.91826$249.23

Expert Answer

---

. . .