Least Squares Regression Analysis - No Idea

Click For Summary
SUMMARY

The discussion centers on Least Squares Regression Analysis (LSRA), a method used to fit a straight line through a set of non-collinear data points. The student, a first-year undergraduate in Engineering and Computing Science, initially struggled with the concept as it was not covered in their Linear Algebra course. After extensive research, including resources like Wikipedia and Wolfram Mathematics, the student successfully grasped the fundamentals of LSRA and solved the assignment question. The attached dataset 'exercise.xls' was integral to the problem-solving process.

PREREQUISITES
  • Understanding of Linear Algebra concepts
  • Familiarity with regression analysis techniques
  • Basic proficiency in using Excel for data analysis
  • Knowledge of statistical methods for data fitting
NEXT STEPS
  • Study the mathematical foundations of Least Squares Regression Analysis
  • Learn how to implement LSRA using Python libraries such as NumPy and SciPy
  • Explore Excel functions for regression analysis, including the LINEST function
  • Investigate advanced regression techniques like Polynomial Regression and Ridge Regression
USEFUL FOR

This discussion is beneficial for undergraduate students in engineering or computing, educators teaching Linear Algebra, and anyone looking to understand the practical applications of regression analysis in data science.

skullers_ab
Messages
16
Reaction score
0
Hello,
I am a first year undergraduate university student majoring in Engineering and Computing Sc. One of my courses is Linear Algebra. We have been given an assignment in which question no. 2 is out of syllabus. It is on Least Squares Regression Analysis. This has not been taught to us. We (all the students doing this course) have no idea what it is or how to solve problems relating to it. Others have given up and are just doing the rest of the assignment.

I would appreciate it if someone is willing to explain it to me in simpler terms than what I find around on other maths related articles. Perhaps at a level which is sufficient to solve the given problem.

Homework Statement



The whole assignment is attached. This discussion is on question no. 2 which is on page 2 and continues to page 3.

The dataset for the problem is also attached as 'exercise.xls'.


Homework Equations


No Idea


The Attempt at a Solution



I tried reading about the topic online on Wikipedia and Wolfram mathematics but both sources explain it at a level beyond my understanding. What I've managed to figure out is that LSRA is a method to fit a straight line through a set of data points which are not collinear. Uptil now we have been doing this using the approximate best fit line method i.e. just making a line which seems best fit on paper. I have now realized that there is actually a scientific and analytical method of doing it. Interesting.
 

Attachments

Physics news on Phys.org
Ok never mind. I've managed to figure out (after a LOT of reading) what the question is asking and have solved it.

Have appreciated PF and always will.

Cheers
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 6 ·
Replies
6
Views
3K
Replies
3
Views
3K
  • · Replies 11 ·
Replies
11
Views
5K
  • · Replies 23 ·
Replies
23
Views
4K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 21 ·
Replies
21
Views
2K