Calculating a and b in excel (any excel masters)?

  • Thread starter Thread starter PCSL
  • Start date Start date
  • Tags Tags
    Excel Masters
Click For Summary
To calculate the best estimates of a and b in Excel, users can start by learning how to enter summations. A common method is to select a cell, type "=sum(", drag over the desired cells, and close with a parenthesis to display the total. There is a request for clarification on whether the sigma symbol in the equations refers to standard deviation or uncertainty. The discussion emphasizes a desire for guidance without completing the task for the user. Understanding these basics will aid in tackling the original problem effectively.
PCSL
Messages
146
Reaction score
0
Attached is a problem that I am supposed to use excel to find the best estimates of a and b. As I am horrible at excel could someone give me some pointers or an idea how to start? Please don't do it for me, I want to learn how to do it - I just need some help.
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    22.5 KB · Views: 410
Physics news on Phys.org
I guess a simpler question would be how would I go about entering summations in excel.
 
PCSL said:
I guess a simpler question would be how would I go about entering summations in excel.

One way is to select a cell, type "= sum(", then (left click) drag the mouse over the set of cells to be summed (release left click), then finish typing ")". The sum of the contents of the selected cells should then appear in the chosen cell.
 
Thanks for that gneill - can no one help me on the original question? :(
 
Another small question, is the sigma in the equations referring to the standard deviation or uncertainty?
 

Thread 'Magnitude of buoyant force in fluids of different densities'

The book claims the answer is that all the magnitudes are the same because "the gravitational force on the penguin is the same". I'm having trouble understanding this. I thought the buoyant force was equal to the weight of the fluid displaced. Weight depends on mass which depends on density. Therefore, due to the differing densities the buoyant force will be different in each case? Is this incorrect?
View full post »

Similar threads

Undergrad Excel projectile trajectory
  • · Replies 6 ·
Replies
6
Views
2K
Conservation of Momentum in Dynamic Engineering Systems
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
Should Excel macros self-adjust when you delete lines above the affected cells?
  • · Replies 27 ·
Replies
27
Views
4K
Data transfer from MS Excel to PSPP
  • · Replies 16 ·
Replies
16
Views
4K
Excel formula for rounding a value & error
  • · Replies 13 ·
Replies
13
Views
2K
Error in Y-intercept, Least-square+Excel=True?
  • · Replies 2 ·
Replies
2
Views
2K
Unexpected behavior in Excel when sorting
  • · Replies 9 ·
Replies
9
Views
3K
What should I do about my academic supervisor?
  • · Replies 9 ·
Replies
9
Views
1K
How to Combine Gradient Uncertainty with other Uncertainty?
  • · Replies 3 ·
Replies
3
Views
2K