QM 1.3 - Statistics Exercise |
Useful Links |
What goes where in a regression output? Download this Excel spreadsheet (complete with solutions) and practice... Hint: Do not simply click on this link, but download the file and then open it manually in Excel. (Otherwise, the explanations on the "Solution" sheet may disappear.) To download, right-click on the link and choose "Save target as..." from the menu that pops up. You can then choose a place to store the file. Errata: In the printed version of this exercise (which was distributed by tutors), the solution contains a typo: the correct answer for field *1* is obviously 20, not 2. |
The official QM 1.3
Website. A mock-up mathematics
test complete with solutions
has already been posted. Some additional statistics questions are said
to follow suit. (If you are not accessing the net via the University, you
may be required to enter your username and password. In this case,
the username is usually of the type I######@[email protected],
with ###### to be replaced by your ID
number. Use your SMR password to log in.)
This block, the QM Guidelines by EFM Imperator can be downloaded for free at their website, starting March 15. McClave's website. Includes slide shows that guide you through the chapters. (You will need PKZip for Windows or WinZip to decompress the files. To view the slide shows you will need PowerPoint or the PowerPoint Viewer, which can be downloaded for free.) David M. Lane's online statistics textbook Hyperstat is very useful for reviewing those QM 1.2 topics some of us missed. Are you trying to get the intuition behind the Least Squares approach? Here is a nice visualization that explains how the technique works. If you have trouble following McClave's explanations, here is a list of online statistical textbooks and courses. Maybe one of them can do the trick for you. |