The other problem is he is even more clueless about Excel so therefore cannot show us any examples of how to create charts and graphs.
Two of the major problems I'm having is we are being taught Statistics by a lecturer who has never taught it before and also I think is learning as he is writing on the whiteboard. I will go back to your link above and have another go. I think I may have created them in a totally different spreadsheet and then copied and pasted from memory. When you say the Box Charts are linked to other spreadsheets, I'm sorry again but I'm not sure how to fix the problem. My Sheet 1 Row 103 &105 Std Deviation & Range were created by Excel using Data Analysis, so if there is something incorrect I'm not sure of how to fix it. In the other files they are jpegs of another programme I found at some university that worked it all out for me and shows outliers etc but it not excel!Īh yes that Sheet 4 now that you have reminded me did create a formula to remove highs and lows, so now I'm guessing as to whether this is the correct way or not? It certainly shows all the formulas but when I tried it on Sheet 1 I kept getting errors, so I don't know what I'm doing? Sheet 1 is my main page with Sheets 2 & 3 with a few workings on it and on Sheet 4 there is another version of how to create boxplots with outliers etc, but to be honest it's got beyond my capability.
When you download the file you will see the main EX3 spreadsheet which has 4 sheets to it. I think the link above is OK I'm still trying to figure out mediafire? I thought I had put all my files in one folder but it appears to have separated them. Those links you posted are actually the ones I was following to create what I have, but I don't think they are complete in the fact that they are not showing the outliers.
0 kommentar(er)
