ATAR Notes: Forum
VCE Stuff => VCE Mathematics => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE General & Further Mathematics => Topic started by: clarke54321 on April 24, 2016, 09:30:20 am
-
Hi everyone,
So my first SAC is coming up in one weeks time and it is based on excel.
Over the holidays I have been practicing all of my skills on excel with data for maybe 15 to 20 years. I have been given a practice SAC by my teachers for about 100 months of data and when I am plotting say a scatter-plot it looks totally abnormal with no clear or concise points.
Also, I am unsure what my teachers mean when they say use randbetween function to find a starting point to work off.
I am really stressed about this and would really appreciate any advice!!
Thank-you
-
Also, I am unsure what my teachers mean when they say use randbetween function to find a starting point to work off.
randbetween is essentially an excel function for generating random numbers given two parameters (a lower and an upper bound/limit).
For example, if i wanted to generate a random number between 10 and 20, the function inside my excel cell would look something like:
=RANDBETWEEN(10,20)
It seems like your teacher wants students to have different starting points, given the mention of this function. For example, in your data of 100 months, you could use the randbetween to generate a starting point (this will be different for every student).
=RANDBETWEEN(1,100) will give you a month from Month 1 to Month 100 (as an example, I don't know what your SAC is about or the specific requirements of it, so i'm only giving you advice on this function in general).
-
randbetween is essentially an excel function for generating random numbers given two parameters (a lower and an upper bound/limit).
For example, if i wanted to generate a random number between 10 and 20, the function inside my excel cell would look something like:
=RANDBETWEEN(10,20)
It seems like your teacher wants students to have different starting points, given the mention of this function. For example, in your data of 100 months, you could use the randbetween to generate a starting point (this will be different for every student).
=RANDBETWEEN(1,100) will give you a month from Month 1 to Month 100 (as an example, I don't know what your SAC is about or the specific requirements of it, so i'm only giving you advice on this function in general).
Thanks so much for explaining this for me. My SAC is on data analysis where I will be plotting scatter plots, time series and so forth. I've been given so much data that all of my graphs and plots look quite peculiar since I have been used to working with smaller amounts.
Thanks again! :)