UNIT9. SPREADSHEET


ACTIVITIES Nº1

1.- Look 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..."


Age
People
1900
18.616.630
1910
19.990.669
1920
21.388.551
1930
23.677.095
1940
26.014.278
1950
28.117.873
1970
30.582.926
1980
34.008.759
1981
37.742.561
1991
39.433.942
2001
41.116.842
2010
47.021.031




2.- What kind of chart would you use to present the following types of data?

a) elections results - Pie chart
b) Changes in petrol prices over time - Area graph/Line chart
c) Population of the different Spanins regions - Bar chart
d) Distribution of pupils in the class by height range -  Bar chart

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

3.- Make an invoice/bill.

DATE
INVOICE#


BIIL TO

PICK-UP LOCATION/CONTACT










P.O. NUMBER
TERMS
DUE DATE
FEIN#

ACCOUNT#









SERVICED

DESCRIPTION
TRACKING
QUANTITY
RATE
AMMOUNT
























































































































TOTAL DUE





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.

18%=(parcial/160)*100%; bill=28.8

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

18%=(parcial/300)*100%; bill=54 

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.
20 km=20000 metres

slope%=(800/20000)=  0.04 %

4º) An article was bought for 60€ and sold for a profit of 15%. Calculate the selling price.

15%=(parcial/60)*100%= 9 

selling price -> 69  


5º) In a school of 520 student, 35% play games. How many pupils don´t play anything.

75%=(parcial/520)*100%= 390

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

%=(4000/5000)*100=80%

amounto profit made->20%

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).

"avarage"=(18/8)=2.25

b)      What´s the MODE number.

The MODE number its 5

c)      Represent the information with a table.

Day
Number of 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 its TEAM "E"

-    b) Calculate the MEAN number of goals scored per match. 

     
First match
2,3333333
Second match
2,3333333
Third match
3.6666666
Fourth match
3,6666666

     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. 

       Alfredo: 1.70m-70kg.
       Juan: 1.65m-60kg.   
       Laura: 1.65m-55kg.
       María: 1.67m-60kg.
       etc...etc..
      Mean of Height 1,667
      Mean of Weigh 61,25
      Chart of all Height
      Chart of all Weing.
      Write down your own conclusion about the resolt.

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
(in centimeters)
Breed
Average Height
(in centimeters)
Collie Doberman Poodle
German Shepherd
Beagle
Golden Retriever
63
66
31
63
36
59
Labrador Retriever
Chihuahua Cocker Spaniel Bull Mastiff
Shih Tzu
58
20
34
65
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?

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

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?

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

No hay comentarios:

Publicar un comentario