Complete the attached worksheet on Volcanism and Earthquakes. Upload back here w

Complete the attached worksheet on Volcanism and Earthquakes. Upload back here when complete. Use your lecture notes and your chapter reading to guide you. You may submit more than once. This is a graded assignment.
This assignment is a word document and can be completed on your computer and then submitted. This assignment does not have to be printed. Recall some of the rocks we discussed and the process of plate tectonics. Much of the past info we just learned will come together in this assignment. Because it brings many concepts together that we learned, ensure you allocate enough time to this assignment. Take each task one step at a time. Do not read through the whole thing at once, you will get overwhelmed. If at anytime you have questions, email me and I will clarify. Don’t spend tons of time in confusion. The assignment is time consuming enough. Reach out!
Example Graph of Eruption Size vs. Eruption Frequency in Google Sheets with Instructions
Steps for making a graph in Google sheets:
1. Open Google sheets
2. Click on the + sign at the upper left under where it says “Start a new spreadsheet”.
3. Enter the Frequency of Eruptions into column A and size of eruptions in column B.
4. Select both columns A and B including titles (highlighted text in step 3.
5. Click on “Insert Chart” which is the 4th icon from the right in the G. sheets menu.
6. Click on “Chart Type” and select “Scatter Chart.”
7. Select “Customize” under where it says “Chart Editor”
8. Click on “Series” and find the “Trendline” box and select it.
9. Below the “Trendline” box, select Logarithmic
10. Below the “Line Opacity” box, click on the “Label” menu, and select “Use Equation”–this will insert an equation at the top of the chart below the title. You can then use this equation to extrapolate to a “1000-year” lava flow by substituting 1000 for x in the equation. When you do this, you will have to use the natural log. function on a calculator.
( I have attached pictures of graphs for examples).
To get this graph in Excel, you need to select your data ranges with eruption frequency in the left column and size of eruption in the right column. Then you have to insert a scatter chart without any markers. Then you can right click on a date point, select trendline and choose “logarithmic” and then scroll down in the same menu where you selected the trendline and click on “Display equation on chart”. In my chart (see below), I selected linear and logarithmic (curved) trendlines for comparison. You can then use your trendline equation and substitute 1000 years for the x-variable to extrapolate for a “1000 year” lava flow.