Purchase Solution

Regression Correlation statistical techniques

Not what you're looking for?

Ask Custom Question

1. We use Microsoft EXCEL to quickly graph and compute the essential output of these techniques. What are the advantages and disadvantages of using EXCEL for regression and correlation statistical techniques? Or alternatively, is there any advice you would like to give the newbie in using this EXCEL tool?

2. Linear Regression and Correlation are two analytical techniques used to forecast the value of the dependent variable based on the independent variable and test the strength of the relationship between the two variables. With Microsoft EXCEL we can analyze a wide variety of large data sets. Discuss some real data from business, sports or personal finance that could be used in this analytical technique. Identify the independent and dependent variables in the data set. What relationship do you expect to be found between the two variables?

Purchase this Solution

Solution Summary

Detailed explanation of problems.

Solution Preview

1. Calculations for regression and correlation statistical techniques can be highly complicated and tedious. Doing these calculations by hand can be very cumbersome, and almost practically infeasible for large problems. This is where MS Excel or any other utility can come in handy to find regression equations and/or correlation coefficients. There are inbuilt menus in Data Analysis Add-in, namely correl(.,.) and regression functionalities, that can be used very effectively in quickly and easily calculating and plotting ...

Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Introduction to Finance

This quiz test introductory finance topics.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce