Calculate the t test statistic and two-tail p-value

Reference no: EM13153776

Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (b) Make an Excel worksheet to calculate SSxx , SSyy , and SSxy . Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (c) Find t.05 for a two-tailed test for zero correlation. (d) Calculate the t test statistic. Can you reject ρ = 0? (e) Use Excel's function =TDIST(t,deg_freedom,tails) to calculate the two-tail p-value.

Reference no: EM13153776

Questions Cloud

What is the rate of return on project : The Wine Press is considering a project which has an initial cash requirement of $187,400. The project will yield cash flows of $2,832 monthly for 84 months. What is the rate of return on this project?

A t-shirt manufacturer has fixed costs : A T-Shirt Manufacturer has fixed costs of 125,000 dollars. She sells the T-Shirts for 10 bucks and has variable costs of 4 bucks per shirt. How many T-shirts does she need to sell to break even?

Main reason for the unfavorable total budget variance : What is the main reason for the unfavorable total budget variance?

Usa-mexico border assay : Do you think the USA-Mexico border should be open, or closed?? What are the things that I should look at when I'm considering what to write for this essay about the USA-Mexico border?

Calculate the t test statistic and two-tail p-value : Calculate the t test statistic. Can you reject ρ = 0? (e) Use Excel's function =TDIST(t,deg_freedom,tails) to calculate the two-tail p-value.

Problem on annual depreciation expense : A machine cost $80,000, has annual depreciation expense of $16,000, and has accumulated depreciation of 40,000 on December 31. On April 1,2011 when the machine was fair value of 32,000, it is exchanged for a similar machine with a fair value of 96..

What is meant by saying debt is tax-favored? : This is a test of your comprehension of the key concepts covered in this section of the course. In writing your essay assume you are writing for someone who knows nothing about the subject. Tell them what they need to know in order to understand the ..

Specific e-commerce business : Ted has a website with information about his stores. Identify and explain two additional ways Ted could use the internet in his business. Tie each use to a specific e-commerce business model and explain how that model applies.

Market model patterns of change : Describe the industry and explain the general pattern of change of the particular market model and hypothesize the basic short-run and long-run behaviors of the model in the industry you have chosen in a "market economy."

User Account

All Pages