Question: I am running data through both correlation and regression analysis in MS Excel Toolpak. For the correlation analysis, it returns a correlation co-efficient of -.7159842.

I am running data through both correlation and regression analysis in MS Excel Toolpak. For the correlation analysis, it returns a correlation co-efficient of -.7159842. However, when I run the exact same data through regression analysis, it results in p-value of .7159842. I've checked and double checked I am putting the variables in the correct input rows. How come I am getting a negative result with one analysis, and positive with the other? Am I doing something wrong?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Running head: PATIENTS 1 Geriatric Patient Analysis Kaitlyn Knowles Indiana Wesleyan University STAT-535A - Statistics for Business Decision Making Geriatric Patient Analysis Today, people are living...

Welcome! Please read this page very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in this document...

LIQUIDITY - PROFITABILITY TRADEOFF: AN EMPIRICAL INVESTIGATION IN AN EMERGING MARKET Abuzar M. A. Eljelly This study empirically examines the relation between profitability and liquidity, as measured...

!Do all calculations witin excel! !Please show formulas if used! 2. The sample data found in Moving Data have been collected by the owner of a moving company who wishes to predict the total number of...

c) Describe the relationship between these sprint times and throwing distances. (2 marks, C) d) State which data points could be identified as outliers, and explain why you chose them. (2 marks, C)...

1. The weight of a product is measured in pounds. A sample of 64 units is taken from a batch. The sample yielded the following results: X = 70 lbs. and s=16 lbs. Calculate a 99 percent confidence...

What could be the "Anticipated Contributions" based on the topic: THE CORRELATION BETWEEN THE AMPLATS SHARE PRICE AND PLATINUM PRICES Abstract Background AMPLATS is a large platinum producing company...

HELP! How to solve this project. PROJECT 1: USING THE AMPS MODEL TO ADDRESS THE QUESTION OF LOAN REPAYMENT Lending Club is a U.S.-based peer-to-peer lending company (www.lendingclub.com),...

This is the Table I need to complete These are the files that were provided to solve the problem This is an example of a completed Table All bonds issued by HomeDepot Inc. Project-Part 2 (Total 15...

1) Just as you did for the first part of this project, download return data from 01/2011 12/2015 for the following stocks: CAT (Caterpillar Inc.), JPM (JP Morgan Chase & Co.), PG (Proctor & Gamble...

What are the major factors that influence customer expectations for desired service?

Tej Dhakars company wants to establish kanbans to feed a newly established work cell. The following data have been provided. How many kanbans are needed? Daily demand 250 units Production lead time...

If the net standard costing variance of a business is considered significant in relation to total production cost, then the net variance should be: Multiple Choice assigned to cost of goods sold....

In this problem we will assume all cash flows occur at the BEGINNING OF THE PERIOD (Annuity Due). Therefore, you need to set the calculator to BEGIN. Problem : Assume you are 32 years old and plan to...