Reference no: EM131960929
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 service online. The following data show respondents age and answer to the questions. " How many minutes do you browse online retailers per week.
Age (X) Time (Y)
23 513
51 207
45 201
33 405
56 141
61 141
39 297
23 501
22 531
46 273
53 147
34 381
20 591
18 609
22 519
1) Use data>Data Analysis>Correlation to compute the correlation checking the Label check book
2) Use the excel function=CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error
3) The strength of the correlation motivates further examination
a. Inser scatter (X,Y) pilot 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 trending and checking boxes
4) Read directly from the chart:
a. Intercept=
b. Slope=
c. R^2
5) Perform Data>Data Analysis>Regression
6) Read the standard error in the regression output?
7) Based on the regression output, what is the equation of the regression line?
8) Use the excel to predict the number of minutes spent by a 40 year old shopper. Enter=followed by the regression formula. Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results.
|
What is the total amount posted to the accounts receivable
: What is the total amount posted to the accounts receivable and fees earned accounts from the revenue journal for April?
|
|
Scores are ordered from least to greatest
: Here are the scores of 16 students on a geography test.59, 60, 61, 62, 63, 75, 75, 76, 76, 78, 79, 80, 81, 82, 88, 92
|
|
Confidence interval for the slope
: If sd = 3.35, give a 95% confidence interval for the MPG of a car with a 3 liter engine.
|
|
Same for the confidence interval set
: Do the same for the confidence interval set at 80%. Include an example with actual numerical values for the intervals in your post to help with your explanation
|
|
Read the standard error in the regression output
: Studies have shown that the frequency with which shoppers browse internet retailers is related to the frequency with which they actually purchase
|
|
Prepare journal entries for twenty times two concerning data
: Prepare all journal entries for 20 times 2 concerning the following data for a medical clinic that performs elective laser surgery that corrects vision.
|
|
Value of s before collecting data
: Suppose the investigators had made a rough guess of 181 for the value of s before collecting data. What sample size would be necessary
|
|
Confidence interval for the true average echo
: Calculate a 99% (two-sided) confidence interval for the true average echo duration µ. (Round your answers to two decimal places.)
|
|
Type of induction motor
: A CI is desired for the true average stray-load loss µ (watts) for a certain type of induction motor when the line current is held at 10 amps
|