This discussion is now closed.
Check out other Related discussions
- revision timetable help
- New semester new start
- Architectural Engineering or Architecture?
- Please give some feedback on this cv!!! Be honest. Any and all criticism is welcome
- Study partner
- Looking for a study partner
- Study partner
- 'I got into uni!' CELEBRATION thread
- Why Choose DMU? Our Recent Teaching Excellence Framework Award!
- Optometry Interview Plymouth
- Monthly Expenses
- Mature Student commuting
- Kent or Hertfordshire for MS in CS
- Choices
- Dropping a 4th Alevel while waiting for an offer
- British College of Interior Design
- Quantity surveying at ljmu, ntu or loughborough uni
- is this enough to get into nursing?
- Royal Holloway diversity
- OCR Computer Science 2023
EXCEL HELP PLS! REP! - Excel Solver Add-In
Hi, I'm using solver to minimize a value of chi squared by changing parameters... and it's totally not working for me.
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Hi, I'm using solver to minimize a value of chi squared by changing parameters... and it's totally not working for me.
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Hi, I'm using solver to minimize a value of chi squared by changing parameters... and it's totally not working for me.
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
bump
bump
bummmmp
I don't know sorry, i'm only in first year at durham so haven't had to use the formula yet... but go here and ask http://www.physicsforums.com/, there are some pretty clever people there so I'm sure you'll get an answer!
TheRandomer
Hi, I'm using solver to minimize a value of chi squared by changing parameters... and it's totally not working for me.
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
Afaik I'm doing everything correctly, and solver comes up with a value.. only it's absolutely identical to before I used the add in. And I can make chi squared huuuge (so I know there are smaller values) and it still doesn't do anything.
Is anyone able to help me with this?
It's for my lab report, I'd really really appreciate it if you guys could help me!!!
I attached my spreadsheet.
Thanks, TheRandomer
See attached.
I think that your problem lies with the range of cells that you've specified for Solver to change. You've included both columns A and H, but the values in H depend upon the values in A, which may well be what's causing the problem.
If you remove column H from this range then run Solver, it finds a Chi squared value of 8.5847E-13 - hopefully this is more like what you wanted.
Illusionary
See attached.
I think that your problem lies with the range of cells that you've specified for Solver to change. You've included both columns A and H, but the values in H depend upon the values in A, which may well be what's causing the problem.
If you remove column H from this range then run Solver, it finds a Chi squared value of 8.5847E-13 - hopefully this is more like what you wanted.
I think that your problem lies with the range of cells that you've specified for Solver to change. You've included both columns A and H, but the values in H depend upon the values in A, which may well be what's causing the problem.
If you remove column H from this range then run Solver, it finds a Chi squared value of 8.5847E-13 - hopefully this is more like what you wanted.
Thanks for helping
I'm trying to get a more accurate estimate on the correct gradient though, so the intercept and gradient need to be my parameters.. Even if I change the H column values so as not to depend on A column values, it still doesn't work. Eek! This is insane!
Silly vista.
Related discussions
- revision timetable help
- New semester new start
- Architectural Engineering or Architecture?
- Please give some feedback on this cv!!! Be honest. Any and all criticism is welcome
- Study partner
- Looking for a study partner
- Study partner
- 'I got into uni!' CELEBRATION thread
- Why Choose DMU? Our Recent Teaching Excellence Framework Award!
- Optometry Interview Plymouth
- Monthly Expenses
- Mature Student commuting
- Kent or Hertfordshire for MS in CS
- Choices
- Dropping a 4th Alevel while waiting for an offer
- British College of Interior Design
- Quantity surveying at ljmu, ntu or loughborough uni
- is this enough to get into nursing?
- Royal Holloway diversity
- OCR Computer Science 2023
