Unit 9-Spreadsheet

ACTIVITIES Nº1

1.- Lool for data on the Internet and make a chart showing the population of Spain from 1900 to the present. Now write a paragraph in your blog summarising the changes. For explample: "from...to ..., increase/rise/fall/decrease/remail  the same/pak..."



2.- What kind of chart would you use to present the following types of data?
Now work in pairs, create a chart for each one and copy them into your blog.

a) elections results: Bar graph.
b)Changes in petrol prices over time: Line graph.
c) Population of the different Spanins regions: Circle graph.
d) Distribution of pupils in the class by height range:Column graph.

3.- Make an invoice/bill.

Cantidad	Denominación		Precio	Total
2	Portátil		87	174
3	Impresora		95	285
1	Televisión		230	230
6	Ratón		8	48
2	Pantalla		140	280
4	Auriculares		60	240
		Total		1257
		IVA	16%	274,4
		Suma T		1531,4

ACTIVITIES Nº2: PERCENTAGE: 

A percentage is a fraction with 100 on bottom. It tells you “an amount out of 100/Percent/%/in every 100”.

Percentages, fractions and decimals are linked: 7%  =7/100=0.07

To calculate a percentage you have to use this equation:
PERCENTAGE= (PARCIAL/TOTAL) *100%.

E.g.

(i) VAT means Value Added Tax: 18%

(ii) SLOPE of a road: 10%

(ii) PROFITS: Often the profits, loss or discount are given in percentage: 20%Profit (Profit/Cost*100%).

Exercises:

1º) A bill has 18%VAT of a product that cost 160euros NET. Calculate the total bill including this VAT.
160€x18%=2880:100=28,8€.

2º) A garage bill for repairs a car came to 300euros including VAT at 18%. Calculate the bill before VAT was added.

3º) Often a slope is given in percentage (slope%=vertical change/horizontal change). Calculate the slope of a mountain when you hiking it along 20km and 800metres of height.
800:20000=0,004=4%.

4º) An article was bought for 60€ and sold for a profit of 15%. Calculate the selling price.
15%+1=1,15x60€=69€.

5º) In a school of 520 student, 35% play games. How many pupils don´t play anything.
520x35%=182000:100=182€.

6º) A dealer bought a piano for 4.000€ and sold it for 5.000€. Calculate the amount of profit made.
5000-4000=1000€.

ACTIVITIES Nº3.STATISTICS.

MEAN: Mean of set values is the sum of all values divided by the number of values. Mean is the proper name of “AVARAGE”= Sum(all)/number valous(n)"        

MODE: Mode is the value that occurs most often (highest frequency, most popular value).

MEDIAN: Median is the middle value. E.g. 8,9,2,6,2,7,8,10,2… first we write them in according order: 2,2,2,6,7,8,8,9,10 …so the median of this numbers is the 7.

Exercises:

1º) The result of a survey of a number of passengers carried by taxis (a day), was recorded as follows: 

1,1,2,2,2,3,4,5.

• a)      Calculate the MEAN number per taxi (a day). 1+1+2+2+2+3+4+5=20/8=2.2.
• b)      What´s the MODE number. 5.
• c)      Represent the information with a table.

Day	Passengers
1	1
2	1
3	2
4	2
5	2
6	3
7	4
8	5

• d)      Draw a BAR CHAR to illustrate the data.

2º) The frequency distribution table below shows the number of goals score by 6 teams in matches, each team playing four times. (goals by matches, each team playing four times)

• TEAM "A": 0-0-1-2 goals
• TEAM "B": 1-0-2-3 goals
• TEAM "C": 1-2-2-0 goals
• TEAM "D": 1-1-1-2 goals
• TEAM "E": 2-3-3-1 goals. 
• TEAM "F": 2-1-2-3 goals.

-        a) What´s the MODE of the distribution of GOALS.
The mode of distribution of goals is 3, because it is the most number of goals that score on each matches.

-    b) Calculate the MEAN number of goals scored per match. 
     TEAM A___: 0+0+1+2=3/4=0,75.
     TEAM B___: 1+0+2+3=6/4=1,5.     TEAM C___: 1+2+2+0=5/4=1,25.
     TEAM D___: 1+1+1+2= 5/4=1,25.
     TEAM E___: 2+3+3+1=9/4=2,25.
     TEAM F___: 2+1+2+3=8/4=2.

     3º) Do a REPORT using a WORD PROCCESOR but including charts from the SPREADSHEE of the statistics of the HEIGHT and WEIGH of your class. 

Name	Weight	Height
Cristina	58	1,62
Raquel	52	1,61
Lourdes	54	1,63
Belén	57	1,61
Carmen	58	1,6
Irene	49	1,6
Carlota	48	1,59
Santi	63	1,68
Andrés	65	1,72
Jesús	62	1,78
David	68	1,7

Mean
Weight	55,9090909
Height	1,65363636

4º) Do a report of the statistics of your exam marks.

5º) Do a report of the statistics of your free time and write down several conclusion similar to these:

• In the weekend we sleep a eight per cent more than in the weekdays.
• In the weekend we don´t go to the school, and in the weekdays we spend a twenty five per cent of our day in the school.
• In the weekdays we do more homework than in the weekends.
• We spend the same time eating in the weekend and in the weekdays.

6º) Here is some information about the heights of several different dog breeds. 

	Breed		Average Height (cm)
	Collie		66
	Doberman		63
	Poodle		31
	German Shepherd		63
	Beagle		36
	Golden Retriever		59
	Labrador Retriever		58
	Chihuahua		20
	Cocker Spaniel		34
	Bull Mastiff		65
	Shih Tzu		24

a. Organize the data into two groups—

breeds shorter than 40 cm and breeds taller than 40 cm. What is the mean, median, and mode of each group?

	Shother than40 cm
	Poodle
	Beagle
	Chihuahua
	Bull Mastiff
	Shih Tzu
	Mean: 29
	Media: 31
	Mode: 36

	Taller than 40 cm
	Collie
	Doberman
	German Shepherd
	Golden Retiever
	Labrador Retriever
	Bull Mastiff
	Mean: 62,3
	Media: 63
	Mode: 66

b. What happens to the mean, median, and mode of the tallest group ifyou include the shortest breed’s height as an outlier?

That is will change completly.

c. What generalization can you make about the effect on the median andthe mean if the outlier is less than the other data?

d. What happens to the mean, median, and mode of the shortest group if you include the tallest breed’s height as an outlier?

Than in this case the most higher number will be the mode.

e. What generalization can you make about the effect on the median and the mean if the outlier is greater than the other data