Compute descriptive statistics for time and pages viewed

Assignment Help Basic Statistics
Reference no: EM13861490

Use the "Shoppers" Excel file. Answer the following questions:

(1) Compute descriptive statistics for TIME, PAGES VIEWED, and AMOUNT SPENT [Hint: Use the DATA ANALYSIS tool in Excel; choose DESCRIPTIVE STATISTICS; in the Input Range, enter D1:F51 - Excel will compute desstats for the three variables simultaneously.]

(2) Compute the correlation coefficients among the three variables [Hint: Use the DATA ANALYSIS tool in Excel; choose CORRELATION; in the Input Range, enter D1:F51 - Excel will compute correlation coefficients for the three variables simultaneously.].

(3) Using the Excel results, summarize the data and comment on your findings. Carefully interpret the correlation coefficients.

Attachment:- Shoppers_Excel.xlsx

Reference no: EM13861490

Questions Cloud

Create a cpm diagram for the project : Create a CPM diagram for the project and identify the critical path. Generate a Gantt chart showing total floats for all tasks. Try to optimize task scheduling to minimize the number of hiring's and firings (calculate the number), and draw the res..
What is strategic management and what are some of its major : What is strategic management and what are some of its major objectives? Explain in two paragraphs.
Summary on the axis on the march and the fall of france : Please write the one page summary of the topic (your choice) has to be related to the course which is World War 2, and the questions as stated.
How does the line-drawing approach help solve ethical : What makes engineering a true profession
Compute descriptive statistics for time and pages viewed : Compute descriptive statistics for TIME, PAGES VIEWED, and AMOUNT SPENT [Hint: Use the DATA ANALYSIS tool in Excel; choose DESCRIPTIVE STATISTICS.
Explain the meaning of correlation and regression : Explain the Meaning of correlation and regression and its significance? Distinguish between correlation and regression. What are the uses of regression analysis?
What were some of the characteristics of political practice : Why did Parliament succeed in expanding its powers in England at the expense of the king? What were some of the characteristics of political practice in France?
What does it mean if confidence intervals did not overlap : What does it mean if the confidence intervals did not overlap at a 95 percent confidence level?Why is 95 percent considered appropriate for this type of experiment?
What is the z-score for the gestation period baby : What is the z-score for the 34-week gestation period baby? What is the z-score for the 40-week gestation period baby? Which baby weighs less relative to the gestation period?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Conduct an analysis of variance

Conduct an analysis of variance

  Standard deviations for first- and second-time

Standard deviations for first- and second-time and confidence interval

  Create confidence interval for mean money spend on food

The sampled results show that sample mean and standard deviation were $52.00 and $17.50, respectively. Use this information to create a 95% confidence interval for the mean.

  Draw the scatter diagram for this data

Find out the slope, b, and the intercept, a, for the least-squares line. Write the equation of the least squares line.

  Iq is normally distributed with a mean of 100 and a

iq is normally distributed with a mean of 100 and a standard deviation of 15. suppose one individual is randomly

  Test assumption that experienced consultant has satisfaction

Test the assumption that the more experienced consultant has higher satisfaction ratings at the 5% significance level. Show all steps.

  Find if data indicate differences using hypothesis testing

Use Hypothesis testing to determine if the data indicate that there are significant differences among the three therapies? Test at the .05 level of significance.

  Determining p value using one-way anova

Results were analyzed using one -way ANOVA and included SSTR =7 , 102 and SSE = 10 ,511. Are all 8 tapes equally appealing on average? Determine p value?

  Normal-theory method to test for significant differences

Use the normal-theory method to test for significant differences in 12-month mortality between the two groups.

  Confidence interval for the true proportion of voters

Find a 95% confidence interval for the true proportion of voters who approve of the way the government is being run.

  Type of research uses numeric measurement data

a) What type of research uses numeric measurement data? b) What type of research uses a research hypothesis? c) What type of research does not use statistical data analysis?

  Calculate the t-test for sample 1 mean 4 variance 13 and

calculate the t-test for sample 1 mean 4 variance 1.3 and sample size 5 and sample 2 mean 4.3 variance 0.9 and

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd