Use data from Figure 1.3(attached in this question) in Unit 1.4 of CORE (Productivity of labour in producing light) to reproduce annexed chart: “Hours of work required to produce 1000 lumen hours”. Note that the data provided gives lumen hours per hour of labour, not hours of work required to produce 1000 lumen hours. So you will need a calculation to find the right numbers. Again, try to match the formatting of the chart as closely as possible, but with a different coloured line! 3.1. Show and explain how to calculate work time required in seconds for the last observation. link to all data of Figure 1.3 The productivity of labour in producing light: https://ourworldindata.org/grapher/the-productivity-of-labour-in-producing-light-lumen-hours-per-hour-of-labour-1800-to-the-present Data necessary to complete this excel exercise Variable Lumen-hours per hour of labor Time Period 100,000 BC to AD 1992 Year Technology -100000 -100000 Open Fire 17.24 -40000 -40000 Neolithic Lamp 20.00 -1750 -1750 Babylonian Lamp 24.39 1800 1800 Tallow Candle 186.22 1845 1845 Whale Oil Lamp 204.08 1855 1855 Town Gas Lamp 336.70 1875 1875 Early Gas Lamp 3067.48 1895 1895 Welscbach Mantle 12048.19 1920 1920 Carbon Filament Bulb 83333.33 1940 1940 Carbon Filament Bulb 181818.18 1990 1990 Carbon Filament Bulb 1652892.56 1992 1992 Compact Fluorescent Bulb 8403361.34
Please help me to complete following question 3 aswell as question 3.1 I have annexed all data necessary to complete this exercise you might not need all of it but some will be necessary.
3. Use data from Figure 1.3(attached in this question) in Unit 1.4 of CORE (Productivity of labour in producing light) to reproduce annexed chart: “Hours of work required to produce 1000 lumen hours”.
Note that the data provided gives lumen hours per hour of labour, not hours of work required to produce 1000 lumen hours. So you will need a calculation to find the right numbers. Again, try to match the formatting of the chart as closely as possible, but with a different coloured line!
3.1. Show and explain how to calculate work time required
in seconds for the last observation.
link to all data of Figure 1.3 The productivity of labour in producing light:
https://ourworldindata.org/grapher/the-productivity-of-labour-in-producing-light-lumen-hours-per-hour-of-labour-1800-to-the-present
Data necessary to complete this excel exercise
Variable | Lumen-hours per hour of labor | |
Time Period | 100,000 BC to AD 1992 | |
Year | Technology | |
-100000 | -100000 Open Fire | 17.24 |
-40000 | -40000 Neolithic Lamp | 20.00 |
-1750 | -1750 Babylonian Lamp | 24.39 |
1800 | 1800 Tallow Candle | 186.22 |
1845 | 1845 Whale Oil Lamp | 204.08 |
1855 | 1855 Town Gas Lamp | 336.70 |
1875 | 1875 Early Gas Lamp | 3067.48 |
1895 | 1895 Welscbach Mantle | 12048.19 |
1920 | 1920 Carbon Filament Bulb | 83333.33 |
1940 | 1940 Carbon Filament Bulb | 181818.18 |
1990 | 1990 Carbon Filament Bulb | 1652892.56 |
1992 | 1992 Compact Fluorescent Bulb | 8403361.34 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images