Attachment # 00011584 - STAT_HW_11.xlsx
STAT_HW_11.xlsx (463.65 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
XY● False● True● The scatter about the line decreases and the amount of the variation of Y explained by X decreases● The scatter about the line decreases and the amount of the variation of Y explained by X increases● FALSEThe "intercept" and "slope" completely define the best fitting line.● The estimate of Y will be farther from the mean in standard deviations than X is.● The estimate of Y will be closer to the mean in standard deviations than X is.This process is called regression (to move backward) becauseAs a positively signed slope increases● The whole line moves up without rotating● The whole line moves down without rotating● The line rotates clockwise becoming less steep● The line rotates counterclockwise becoming more steepStudies have shown that the frequency with which shoppers browse Internet retailers is related to the frequency with which they actually purchase products and/or services online. The following data show respondents age and answer to the question “How many minutes do you browse online retailers per week?”On this worksheet, make an XY scatter plot linked to the following data:Add trendline and regression equation to the plot.The Standard Error is a standard deviation measuring the scatter of the points about the regression line.Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error.The best fitting line minimizes the vertical distances from the points to the line. Hence,the Y coordinate of a point on the best fitting line provides an estimate or prediction of Y at the value of the corresponding X coordinate.The correlation R measures the strength of the linear association of variables Y and X, and does not have a unit of measure, e.g. feet, acres, pounds, seconds.Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox.Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results.Read directly from the chart:It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data.The scatterplot reveals a point outside the point pattern. Copy the data to a new location in the worksheet. You now have 2 sets of data.Data that are more tha 1.5 IQR below Q1 or more than 1.5 IQR above Q3 are considered outliers and must be investigated.Make a new scatterplot linked to the cleaned data without the outlier, and add trendline and regression equation label.● Weak● Moderate● Strong● X denotes the independent or response variable● X denotes the independent or explanatory variable● Y denotes the dependent or explanatory variable● x denotes an observed value of the dependent variable● denotes the mean value of observations of the response variable● No● YesAge (X)Time (Y)● 0.97● 32.10● 750.02The strength of the linear relationship between Age and the Time isThe intercept is the vertical distance from the origin (where the X and Y axes intersect) up or down to the line. It sets the elevation of the line.● 11.503The strength of the correlation motivates further examination.a) Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis.b) Add to your chart: the chart name, vertical axis label, and horizontal axis label.c) Complete the chart by adding Trendline and checking boxesa) Intercept =b) Slope =c) R2 =Use Excel to predict the number of minutes spent by a 41-year old shopper. Enter = followed by the regression formula.Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R2?Based on the correlation computed in tab "Excel Competencies", does Time tends to increase with Age?Highlight the 4 correct statements. Try not to mix up explanatory and response with dependent and independent.Based on the data in "Excel Competencies", can Y be predicted for a person who is 80?● TRUEBased on the regression output in "Excel Competencies", when Age increases by 1 year, Time decreases byR2 measures the fit of the line to the points. As R2 increases● The scatter about the line increases and the amount of the variation of Y explained by X decreases● The scatter about the line increases and the amount of the variation of Y explained by X increasesPerform Data > Data Analysis > Regression. Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the standard error in orangeUsing your highlighted cells, what is the equation of the regression line?Saeko has a yarn shop and wants to expand the colors in her yarn lines. She sends you the raw data in the "Pivot Table Data" tab.Use the "Pivot Table Data" tab to create a pivot table that shows Saeko the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.This data consists of the number of yards and meters of the color names, and the color types that each name belongs to, sold during her busiest weekend last year. CustomerColor NameColor TypeYardsMetersCorianderWhiteLynxBrownDaffodilYellowPeriwinklePurpleOpalBlueToffeeRubyRedAshWhirlpoolVerdeGreenRegalChocolateMistAlfalfaSkyBlackJadeCreamBlushSapphireIf Saeko wants to expand the colors in both the best selling and the worst selling color type, which two color types should she buy?● Y denotes the dependent or response variable ● x denotes an observed value of the independent variable Using the pivot table that you just created, determine which of the color types sold the largest amount of meters using =MAX()Using the pivot table that you just created, determine which of the color types sold the least amount of meters using =MIN()Highlight the correct answer or answers (#18) for each of the following questions:
STAT PROJECT III

STAT PROJECT III

Question # 00707648 Posted By: Nesio12 Updated on: 07/23/2018 01:10 PM Due on: 08/01/2018
Subject Statistics Topic Data Analysis Tutorials:
Question
Dot Image
Good Morning,

Seeking assistance for assignment attached.

Please make every effort to return by the deadline.

Thank you   
Dot Image
Attachments
STAT_HW_11.xlsx (463.65 KB)
Tutorials for this Question
  1. shortone
    Tutorial # 00707538 Posted By: shortone Posted on: 07/23/2018 02:05 PM
    Puchased By: 3
    Tutorial Preview
    The solution of stat project III...
      Get the Solution
    Attachments
    stat_week_11.xlsx (484.61 KB)
Whatsapp Lisa