Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions: Copy and paste the formulas below in the respected columns in excel and click enter. This should flow all the way down the rows

Instructions:Copy and paste the formulas below in the respected columns in excel and click enter. This should flow all the way down the rows once entered but if not, highlight and drag the cursor down until you get to row 56.

Calculation of venison meat: Q. 9 & 10

Total Meat Produced in 2012 (Insert into F2): =(B2*59)+(C2*85)+(D2*32.5)+(E2*60)

Total Meat Produced in 2013 (Insert into K2): =(G2*59)+(H2*85)+(I2*32.5)+(J2*60)

Total Meat Produced in 2014 (Insert into P2): =(L2*59)+(M2*85)+(N2*32.5)+(O2*60)

Total Meat Produced in 2015 (Insert into S2): =(Q2*85)+(R2*60)

Total Meat Produced in 2016 (Insert into V2): =(T2*85)+(U2*60)

Total Meat Produced in 2017 (Insert into Y2): =(W2*85)+(X2*60)

  1. How much venison meat is produced by Monongalia, Marion, and Preston Counties from 2012?
  2. Monongalia:
  3. Marion:
  4. Preston:

  1. How much venison meat was produced by Monongalia, Marion, and Preston Counties from 2017?
  2. Monongalia:
  3. Marion:
  4. Preston:

Instructions:To find the total amount of venison meat produced in a given year you will need to go to the bottom row where it says "Total", in each column of the "Total number of Deer Harvested" for each given year. Underneath the last data entered you will highlight the cell, notice that there is an arrow box to the right, click on that then select "SUM" to get the total amount of deer harvested for each year. If you do not have this option type "=SUM()" into that cell and select the whole column of the"Total number of Harvested Deer", close the parentheses then click enter.

  1. What is the Total meat produced by the state of West Virginia in 2012 to 2017?

Use your data to fill in the table below:

Table 1: Commercially Processed Red Meat in Appalachia

Year

Commercially Processed Red Meat

Total venison meat produced

2012

7,400,000.0 lbs

2013

7,300,000.0 lbs

2014

6,700,000.0 lbs

2015

6,700,000.0 lbs

2016

7,300,000.0 lbs

2017

7,900,000.0 lbs

(Hall, 2020)

  1. Compare your answers from question 11 to the total amount of beef produced by conventional methods between 2012 to 2017 (Table 1). Has the meat produced by both of these methods increased or decreased since 2012?

  1. Was your original hypothesis (question 9) supported by the data?

Instructions:Now to graph the total number of deer harvested in WV Counties we need to be in the "Total Deer Harvested" tab in excel sheet in the dataset for the next set of questions.

  1. Provide a graph of the total deer harvested of 2012 of all WV Counties. Expand the graph since they are 55 counties in the state.

Paste Graph Here

  1. Provide a graph of the total deer harvested of 2017of all WV Counties. Expand the graph since they are 55 counties in the state.

Paste Graph Here

Part C. Hunting in the Arctic. Indigenious people's way of life in the Arctic and conflicts with Food Security.

Instructions:Go to the Solutions Journal site on "The Continued Importance of Hunting for Future Inuit Food Security" here: https://www.thesolutionsjournal.com/article/continued-importance-hunting-future-inuit-food-security/ and read to answer the following questions

  1. What are the listed limitations for agricultural food production for Indigenious communities in the Arctic?

  1. What are the six themes for improving food security that the Nunavut Food Security Coalition identified?

  1. What is the difference in price to feed a family of four in Northern Canada compared to Southern Canada?

  1. What was one of the listed on the "on-the-land programs" that have been developed to support hunting knowledge sharing within communities?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Survey of Mathematics with Applications

Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde

10th edition

134112105, 134112342, 9780134112343, 9780134112268, 134112261, 978-0134112107

More Books

Students also viewed these Mathematics questions