Statistics and Data Analysis with Excel: Intermediate

Macquarie moves beyond descriptive statistics into comparisons and relationships. Pivot tables support the exploration of categorical data, followed by goodness-of-fit and two-sample tests. Correlation and simple regression complete the main sequence. Learners can compare this focused progression with a broader business-statistics course that introduces several tools at once.

What you will learn

• Explore categorical data with pivot tables.
• Compare samples using an appropriate statistical test.
• Interpret correlation and a simple regression model.

Who this suits

Intermediate learners with descriptive-statistics knowledge and basic Excel skills, as recommended by the provider.

Before you enroll

Choose an exercise that makes the assumptions visible. A calculated result needs interpretation in the context of the sample, measurement method and question being investigated.

Coursera offers paid enrollment or subscription access. Check the enrollment screen for assessment and certificate terms, trials and any financial-aid options. Provider access terms can change; review them before paying.

Put it into practice

Compare two fictional customer groups in a spreadsheet. State the comparison question, inspect the data and explain why your chosen test fits.

Source and review

This overview is based on the provider's published information, checked on 12 October 2026. It is an editorial assessment, not a claim that we completed the resource. Time filters are approximate study ranges; projects and exercises can take longer.

View the curriculum and current access options at Coursera.

How YellowCourse describes and checks learning resources.