Determine correlation coefficient

Reference no: EM13108542

Corporation owns several companies. Strategic planner for corporation believes dollars spent on advertising can to some extent be the predictor of total sales dollars. As the aid in long-term planning, she collects the following sales and advertising information from twelve of companies for 2011 (in $ millions). Solve by excel and by mega stat

ADVERTISING SALES
12.5 148
3.7 55
21.6 338
60.0 994
37.6 541
6.1 89
16.8 126
41.2 379
18.4 232
26.3 312
48.7 442
58.4 513

1) Is regression statistically significant? Let α = .05. What do you conclude?
2) Point to the regression equation. If x = 40 what is an estimate for y.
3) Determine the Standard Error of the Estimate, Se.
4) Compute the 95% confidence and prediction intervals for values of y for X = 40.
5) Determine correlation coefficient, Interpret.
6) Compute coefficient of determination, Interpret.
7) Verify the coefficient of determination from the ANOVA table values.
8) Verify the standard error of the estimate from the ANOVA table values.

Reference no: EM13108542

Questions Cloud

What psychological symptoms are associated with it : What do we know about Post Traumatic Stress Disorder (PTSD)? What psychological symptoms are associated with it, and what effective treatments exist today (if any) to manage those symptoms?

What is the stanine score for someone who obtains raw score : You have developed a test of musical ability, and would like to report the scores as Stanines, with a mean of 5 and a standard deviation of 2. Raw scores on your test have a mean of 30 and a standard deviation of 5. What is the Stanine score for s..

Describe at least one neurotransmitter : Which parts of the brain are believed to be involved in this disorder, and how do these areas of the brain influence the development and behavior of the individual and describe at least one method which has been used to study this disorder (EEG, f..

Consider how the chi-square test of association : Consider how the chi-square test of association is a nonpapametric procedure that requires different assumptions. Address a real-world situation or problem that would best be analyzed using this technique.

Determine correlation coefficient : Compute the 95% confidence and prediction intervals for values of y for X = 40. Determine correlation coefficient, Interpret.

Determine the ordering cost : A food processor uses approximately, 27,000 glass jars a month for its fruit juice product Because of storage limitations, a lot size of 4.000 jars has been used.

Which of the following approaches to psychotherapy : The criticism of not addressing the causes of psychological disorders is most commonly associated with which of the following approaches to psychotherapy?

What are some memory strategies : How does cognitive psychology help you to understand memory? How can the accuracy of memory be affected by cognitive and schematic processes? What are some memory strategies that could help students dealing with memory problems or inaccuracies?

Discuss one type of schematic processing : provide an illustration of at least two cognitive processes that can lead to bias or inaccuracy in your own memory. also, discuss one type of schematic processing, and how this schema led to a distortion of events .

User Account

All Pages