Real-World Data Analysis Using Google Sheets


Google Sheets and Real-World Data will be utilised to demonstrate the concepts in Univariate, Bivariate and Time Series Data Analysis. This will allow an opportunity for participants to explore the real-world applications of the concepts covered in Years 11 and 12.
Key concepts include:
1) Construction of dot plots, stem plots, bar charts, histograms, and box plots.
2) Construction of scatter plots (with line of best fit and least squares regression equation), residual plot, normal probability plot, two-way frequency table, segmented bar chart, and parallel boxplots. Calculations of correlation coefficient, and coefficient of determination.
3) Calculation of measures of centre, spread, and 95% CI.
4) Construction of time-series plot, smooth time series data by using a simple moving average, calculate seasonal indices by using the average percentage method, deseasonalise a time series by using a seasonal index, fit a least-squares line to model long-term trends in time series data.

Participants to bring along a laptop or any device that can access Google Sheets. Laptops will be convenient to work with.

Nazim Khan

Session Code Session Date Session Start Session Finish Session Location Places Remaining
D-E-2 06/12/2018 02:30 pm 04:40 pm La Trobe University
I-J-3 07/12/2018 02:30 pm 04:40 pm La Trobe University


Please enter your email address & password to login and enrol for options.




Forgot Your Password?

Please enter your email address to retrieve password.





Create an account

Please try the forgotten password option using your current or old email address - you may already be on our system, otherwise create a new account.




Annual Sponsors