20240414 MY MIDTERM EXAM REVIEWER

My documents (view only)                                                                                                          Click: Google Document and Google Sheet

REFERENCES: (click the colored text)

All data used are retrieved from: Statistics with Technology by Dr. Kozak and I-yuan Chiang YouTube video 2024 Midterm Exam (One Dollar)

This note is just for my self-study session, but for educational purposes, others can use it as a reference. GOOD LUCK!

PROBLEM 1:

DATA: Motorcycle Brands

BrandFrequency
Gogoro3
Honda1
Kymco6
Pgo1
Sam yang8
Suzuki2
Yamaha4

SUM:(input)

Brand

Frequency

Gogoro

3

Honda

1

Kymco

6

Pgo

1

Sam yang

8

Suzuki

2

Yamaha

4


=sum(B2:B8)

Relative Frequency

Brand

Frequency

Relative Frequency

Gogoro

3

=then click the variable←

Ex. =B2/25 OR =B2/B9 


THEN click  ENTER


If autofill don’t appear, click the button and release

Honda

1


Kymco

6


Pgo

1


Sam yang

8


Suzuki

2


Yamaha

4



25


ANGLE

Brand

Frequency

Relative frequency

Angle

Gogoro

3

0.12

=(select ←) *360


=C2*360

Honda

1

0.04


Kymco

6

0.24


Pgo

1

0.04


Sam yang

8

0.32


Suzuki

2

0.08


Yamaha

4

0.16



25




FINAL

Brand

Frequency

Relative frequency

Angle

Gogoro

3

0.12

43.2

Honda

1

0.04

14.4

Kymco

6

0.24

86.4

Pgo

1

0.04

14.4

Sam yang

8

0.32

115.2

Suzuki

2

0.08

28.8

Yamaha

4

0.16

57.6


25

1

360


BAR GRAPH

COPY PASTE THE NEEDED


Or just by selecting the column and add— changing the  label based on the series letter

CLICK Tt – brand

or

PIE GRAPH

QUESTION 2  

2.3: Other Graphical Representations of Data - Statistics LibreTexts

Example  2.3.3 Time-series plot


Time (months)

0

1

2

3

4

5

Weight (pounds)

200

195

192

193

190

187

or 
(you can change the minimum and maximum to see the data clearly)

QUESTION 3 MEAN, MEDIAN, MODE

https://youtu.be/naicRawk9hw?t=1373


3.1: Measures of Center - Statistics LibreTexts

3.1.2



6.8

8.2

7.5

9.4

8.2

6.3


Arrange left to right  

Small to big


  1. 7pts

6.3

6.8

7.5

8.2

8.2

9.4


2. Median 2pts

7.5_ 11.6   _8.2


3. Mean

 =AVERAGE(A1:A6)


7.733333


IF MODE IS NEEDED :   8.2


QUESTION 4

https://youtu.be/naicRawk9hw?t=1490

3.2: Measures of Spread - Statistics LibreTexts


The vet blabla  . weights (kg), 15.3, 20.6, 9.8, 17.6, 18.2

Find


  1. Mean

sum:


x (small to large)

9.8

15.3

17.6

18.2

20.6

81.5

Average

16.3

  1. Median

17.6


  1. Min 9.8

  2. Max  20.6

  3. range

Max-minimum + range

10.8


FILL ALL THE BLANKS


x-xbar

x (small to large)

X-X BAR(mean)

9.8

(A=select the ←-16.3)

-6.5

15.3

-1

17.6

1.3

18.2

1.9

20.6

4.3

16.3

0


(x-xbar)^2


x (small to large)

X-X BAR(mean)

(x-xbar)^2


9.8

-6.5

42.25


15.3

-1

1


17.6

1.3

1.69


18.2

1.9

3.61


20.6

4.3

18.49


16.3

0

WHEN AUTOFILLING ITS DIFF


x (small to large)

X-X BAR(mean)

(x-xbar)^2

9.8

-6.5

42.25

15.3

-1

1

17.6

1.3

1.69

18.2

1.9

3.61

20.6

4.3

18.49

16.3

0

67.04

  1. Standard Dev  https://youtu.be/naicRawk9hw?t=2138

3.2: Measures of Spread - Statistics LibreTexts

We use n-1 in the denominator when calculating standard dev

 

Standard Deviation Calculator

  1. Sample standard deviation

https://www.calculator.net/standard-deviation-calculator.html?numberinputs=9.8%0D%0A15.3%0D%0A17.6%0D%0A18.2%0D%0A20.6&ctype=s&x=Calculate

4.09


QUESTION 5

3.3: Ranking - Statistics LibreTexts

Find summary for even number of data points

Total Assets (in billions TWD) of Taiwan Banks

257

238

221

240

268

225

278

264

255

254





Fill in the blanks

https://youtu.be/naicRawk9hw?t=2270


n

10

min

221

Q1

238

median

254.5

Q3

264

Max

278

IQR

26

Range MAX-MIN

57

Mean =AVE ()

250

221

min

225


238

Q1

240


254

Median

=(A5+A6)/2

254.5

255

257


264

Q3

268


278

max


Popular posts from this blog

20250303 What is Statistics? Introduction

Image
1: Statistical Basics What is Statistics?  Statistics  is the study of how to collect, organize, analyze, and interpret data collected from a group. (Kozak, 2021) Terms: source :  https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology ) Many find Population and Sample confusing, in order to remember the difference sample is simply just the subset from population. Population – set of all values of the variable for the entire group of individuals. Sample – a subset from the population. It looks just like the population, but contains less data Image from:  https://miro.medium.com/v2/resize:fit:1400/1*83WLnE2QTeOHSjbPJDVKfw.png Image from (click here):  1.1: What is Statistics? - Statistics LibreTexts   I tried to answer the practice questions: Suppose you want to know how Arizona workers age 16 or older travel to work. To estimate the percentage of people who use the different modes of travel, you take a sa...
Read more

20250526 10.1: Regression

Image
 All Data are from: Statistics with Technology Alcohol Content Calories in 12 oz 4.70% 163 6.70% 215 8.10% 222 0.40% 70 4.15% 104 5.10% 162 5.00% 158 5.00% 155 4.70% 158 6.20% 195 Customize step by step Click customize, then click series Trendline Label should be show equation Show R^2 This graph is made through google sheet' here's the file: Google Sheet Simulation tool:  https://phet.colorado.edu/sims/html/curve-fitting/latest/curve-fitting_all.html https://phet.colorado.edu/en/simulations/least-squares-regression Line regression tool: https://www.statskingdom.com/linear-regression-calculator.html For tutorials and more information: One Dollar Youtube Channel 20250526 Live 1 20250526 Live 2 20250526 Live 3
Read more

20250310 Graphical Descriptions (Using Google Sheet/Excel)

Image
QUALITATIVE DATA Example 2.1: Data are from Statistic With Technology, Dr. Kozak  https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.01%3A_Qualitative_Data One Dollar teaches us how to use Google Sheets/Excel to get the given's Relative Frequency. First, copy the provided data and paste it into the Google spreadsheet. Then, add another column, namely "Relative Frequency," next to the Frequency. See the steps below. Note: Letters and Numbers depends on the column and row of the data you want to calculate Category Frequency Relative Frequency (sum=1) Ford 5 0.1 Chevy 12 0.24 Honda 6 0.12 Toyota 12 0.24 Nissan 10 0.2 Other 5 0.1 Total 50 1 This image shows the result after I did the given instructions.  However, these data samples are from the textbook "Statistic with Technology" by Kozak. Reference:  2.1: Qualitative Data - Statistics LibreTexts Example  2.1.2: D...
Read more