Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Other

STA1506 Assignment4 Solutions 2025

Rating
-
Sold
-
Pages
3
Uploaded on
20-09-2025
Written in
2025/2026

STA1506 Assignment4 Solutions 2025 0-7-9-3-2-2-6-4-2-7 Basic Statistical Computing STA1506 Year module Department of Statistics ASSIGNMENT 4 QUESTIONS ASSIGNMENT 04 Unique Nr.: 635796

Institution
Course

Content preview

STA1506 Assignment 04 – Solutions
Unique Number: 635796
Student: [Your Name Here] – Student No: [Your Student No Here]




QUESTION 1(a)
Excel formulas for data in Z3:Z32:
Mean =AVERAGE(Z3:Z32)
Standard deviation (sample) =STDEV.S(Z3:Z32)
First quartile (Q1) =QUARTILE.INC(Z3:Z32,1)
Median =MEDIAN(Z3:Z32)
Coefficient of Variation (%) =STDEV.S(Z3:Z32)/AVERAGE(Z3:Z32)*100



QUESTION 1(b)
Corrected dataset entered in Excel (STA1506_Marks_corrected.csv attached).
Statistic Value
n 52
mean 68.63461538461539
median 71.5
mode [64.0, 53.0, 74.0, 91.0, 84.0, 85.0]
min 3.0
max 95.0
range 92.0
std_sample 20.512099581976855
coefficient_of_variation_% 29.885939430170815
Q1 54.75
Q3 85.0
IQR 30.25
SIQR 15.125

(iii) ToolPak Descriptive Stats: attach Excel output.
(iv) Data rearranged into single column A: see Excel output.
(v) The single-column version is more representative (n=52).
(vi) Compare st.dev. across columns; in single-column version st.dev ≈ 21.15.
(vii) Admission at 85%: 25% of students qualify (13/52). Suggested realistic cutoff ~70%.



QUESTION 1(c)
Histogram and boxplot of 50 electricity costs.

Written for

Institution
Course

Document information

Uploaded on
September 20, 2025
Number of pages
3
Written in
2025/2026
Type
OTHER
Person
Unknown

Subjects

$3.12
Get access to the full document:

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
iQlevel Thakhani Trading enterprise
Follow You need to be logged in order to follow users or courses
Sold
699
Member since
2 year
Number of followers
30
Documents
337
Last sold
1 day ago
Upgrade your iQ scores

All Unisa Modules assignments and exam help.

4.1

89 reviews

5
52
4
15
3
11
2
5
1
6

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions