Statistics Assignment Guidance Unit name: Introduction to Statistical Reasoning (SCI1020)

Hi,

I need help with a statistics assignment.

Unit name: Introduction to Statistical Reasoning (SCI1020)

Please read all instructions carefully and follow them exactly.

Important:
- Use simple English (A2 level)
- Write like a first-year university student
- Do not use complex words or advanced explanations
- Keep answers clear and direct
- Do not overcomplicate anything
- Finish the work in 2 to 3 days maximum

Files:
I will send you:
1. Excel dataset
2. PDF instructions

You must use both files.

General requirements:
- Answer all questions from Q1 to Q5
- Show steps clearly where needed
- Use correct statistical terms but in simple language
- Give short explanations for each answer
- Create graphs using Excel
- The boxplot should be simple and can look hand-drawn

Question 1:

a) Variables:
For each variable in the dataset:
- Identify if it is quantitative or categorical
- If categorical, list its levels
- If quantitative, say if it is discrete or continuous
Use a table if possible

b) Histogram:
- Create a histogram for Monthly_Order_Count
- Describe the shape of the distribution
Mention if it is symmetric or skewed, how spread out it is, and if there are any peaks
Keep the explanation short

c) Total_Spend:
i. Calculate the five-number summary (min, Q1, median, Q3, max)
ii. Identify outliers and show how you found them
iii. Draw a simple boxplot based on your results
iv. Compare mean and median and explain what this says about the shape

d) Main Product Category:
- Create a Pareto chart
- Create a pie chart

e) Comparative boxplots:
- Create boxplots of Total_Spend grouped by Membership Level
- Compare the groups and describe differences in spread and center

Question 2 (Sampling):

Use the dataset as the population
For each method, select a sample of 50 customers

Methods:
- Simple random sampling
- Systematic sampling
- Stratified sampling (based on Membership Level)
- Cluster sampling

For each method:
- Explain clearly how the sample was selected
- Calculate the mean Age
- Calculate the mean Total_Spend

Question 3 (Experiment design):

a) Fertilizer experiment:
- Show how plants are randomly assigned
- Explain control, randomization, and replication in simple words
- Include a simple diagram

b) Different sunlight sections:
- Identify the correct design (blocking)
- Explain why
- Include a simple diagram
- Explain control, randomization, and replication

c) Fertilizer and watering:
- Identify explanatory variables and their levels
- Find the number of treatment combinations
- List all combinations
- Show a simple diagram of assignment
- Explain control, randomization, and replication

Question 4 (Repeated measures):

- Explain why this is a repeated measures design
- Identify experimental units, treatments, and response variable
- Include a simple diagram
- Explain control, randomization, and replication
- Answer if blinding is possible and explain

Question 5 (Normal distribution):

- Use normal distribution rules and Z-table
- Show full working steps
- Answer all parts clearly

Writing style:
- Use short and simple sentences
- Avoid complex vocabulary

Final output:
- One clean PDF file
- Clear headings for each question
- Neat and easy to read

If anything is unclear, ask before starting.