Linearizing Data - Solving for Equation | Urgent Homework Help

Click For Summary
SUMMARY

The discussion focuses on linearizing a dataset with specific X and Y values using linear regression techniques. The user has identified that the data does not fit common polynomial or exponential models, indicating a potential maximum in the Y values. Tools like Excel are recommended for performing linear regression analysis, which can help in finding the best-fit line for the given data points. The conversation emphasizes the importance of using appropriate software tools to visualize and analyze data effectively.

PREREQUISITES
  • Understanding of linear regression analysis
  • Familiarity with Excel or similar spreadsheet software
  • Basic knowledge of data visualization techniques
  • Concept of maximum values in datasets
NEXT STEPS
  • Learn how to perform linear regression in Excel
  • Explore data visualization techniques using Excel charts
  • Research the concept of maximum values in statistical datasets
  • Study alternative regression models for non-linear data
USEFUL FOR

Students, data analysts, and anyone involved in statistical analysis or data visualization who needs to understand linear regression and data fitting techniques.

Varad
Messages
4
Reaction score
0

Homework Statement


I have all of the data but I just can't find the equation to linearize it.

X values: 0, 1.98, 3.96, 5.94, 7.92, 9.9, 11.88
Y values: 1.98, 7.13, 9.08, 11.04, 12.57, 14.51, 14.342. The attempt at a solution
I know it is not a parabola, cubic, exponential, or inverse.
 
Physics news on Phys.org
You can do a linear regression on your data. IDK how good a fit you'll get. The y-values reach a maximum before the last x-value.
A spreadsheet like Excel probably already has the tools for this built-in.
 
Thanks, I have no idea if I got the graph correct but something is better than nothing.
 

Similar threads

  • · Replies 3 ·
Replies
3
Views
22K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
Replies
6
Views
4K