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?

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 

Now work in pairs, create a chart for each one and copy them into your blog.

3. Make an invoice/bill.

Cantidad			Denominación				precio	Total
2			Televisor				230	460
2			Impresora				95	190
8			Ratón				8	64
1			Pantalla				140	140
3			Portátil				87	261
10			Auriculares				60	600
					Total			1715
					IVA		16%	274,4
					Suma. T			1989,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%.

(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.04=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%=18200/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
Raquel	50	1,62
Lourdes	50	1,63
Cristina	55	1,61
Belén	52	1,62
Carmen	54	1,6
Irene	49	1,6
Carlota	48	1,59
Santi	63	1,68
Andrés	65	1,72
Jesús	61	1,78
David	68	1,7

     

MEAN
Weigh	55,90909091
Height	1,653636364

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	63
Doberman	66
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?

   

Shorter than 40 cm

Beagle

Poodle

Chihuahua

Cocker Spaniel

Shih Tzu

MEAN: 29

MEDIA: 31

MODE: 36

Taller tan 40 cm

Collie

Doberman

German Shepherd

Golden Retriever

Labrador Retriever

Bull Mastiff

MEAN: 62,3

MEDIA: 63

MODE: 66

  

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

That it will change completly.

c. What generalization can you make about the effect on the median and the 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?

That in this case the  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?