Attachment # 00012320 - MGMT650_HW11_Summer21_Questions.xlsx
MGMT650_HW11_Summer21_Questions.xlsx (29.52 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
XYUse the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error.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.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.Age (X)Time (Y)TotalThe 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 =Read directly from the chart:c) R2 =On this worksheet, make an XY scatter plot linked to the following data:What is the null hypothesis?What is the alternative hypothesis?What is the level of significance?Use Tools - Data Analysis - ANOVA:Single Factor to find the F statistic:What is the F critical value?What is your decision?over another brand. Specifically, she is interested in three different types of bison yarn.Misa's BisonYak-et-ty-YaksBuffalo YarnsAdd trendline, regression equation and r squared to the plot.Saeko owns a yarn shop and want to expands her color selection.Before she expands her colors, she wants to find out if her customers prefer one brand6)7)8)9)10)11)12)13)14)15)16)17)18)Perform Data > Data Analysis > Regression. 19)20)Add this title. ("Scatterplot of X and Y Data")If yes, what is the amount of time, if no, why?Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier,") trendline, and regression equation label.As an experiment, she randomly selected 21 different days and recorded the sales of each brand.At the .10 significance level, can she conclude that there is a difference in preference between the brands?Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orangeUse Excel to predict the number of minutes spent by a 22-year old shopper. Enter = followed by the regression formula.Is it appropriate to use this data to predict the amount of time that a 9-year-old will be on the Internet?From the ANOVA output: What is the F value?Explain in statistical termsCompare the regression equations of the two plots. How did removal of the outlier affect the slope and R2? Explain why the slope and R Square change the way they didAn analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as at a branch located near the mall. He selects 100 transactions at random from each branch and researches the age information for the associated customer. These are the data :Ageless than 3030-5556 or olderIn townmallWhat is the null hypothesis if you want to check if the age patterns of customers are independent of bank location?What are the expected numbers for each cell in a 3 by 3 table if the null hypothesis is true?Use the chi square test to accept or reject the null hypothesis. What is the chi square test statistic?What is the chi square critical value and how many degrees of freedom does it have? Assume alpha is .05.What do you conclude? Studies 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 year?”
Tutorials for this Question
  1. shortone
    Tutorial # 00804316 Posted By: shortone Posted on: 08/02/2021 07:29 AM
    Puchased By: 3
    Tutorial Preview
    The solution of MGMT650_HW11_Summer21...
      Get the Solution
    Attachments
    Solution-00804316.zip (97 KB)
Whatsapp Lisa