Analyse the Dragon Forest sawmill data from last season to produce the following results
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

Analyse the Dragon Forest sawmill data from last season to produce the following results

Section A - Analysis of Last Season

Analyse the Dragon Forest sawmill data from last season to produce the following results:

1) the total number of logs added to the pond during the season

2) the total number of logs cut at the sawmill during the season

3) the maximum log pond size last season

4) the day of the season on which the maximum long pond occurred!

5) the block number in which the maximum long pond occurred a

6) the day of the week on which the maximum long pond occurred' (Monday, Tuesday etc.)

7) how many days of the season experienced a log pond size greater than 500 logs?

8) the average number of logs cut per day? at the sawmill (rounded to 2 decimal places 3)

9) the average number of logs cut on Fridays? at the sawmill (rounded to 2 decimal places3)

10) the total number of logs cut at the sawmill on Fridays

11) the total number of logs added to the pond on Fridays and Saturdays

12) over the full season, which day of the week (Monday, Tuesday etc.) saw the fewest total logs added to the pond (ignoring Sunday, obviously)?

13) over the full season, which day of the week (Monday, Tuesday etc.) saw the most total logs cut in the sawmill?

14) what was the single biggest increase in pond size, from one day to the next?

15) which day of the season saw the biggest increase in pond size?

16) which day of the season saw the fewest logs cut in the sawmill??

17) which day of the season saw the most logs added to the pond?

18) how many days of the season saw more than 200 logs cut at the sawmill?

19) which weeks (1 to 28) saw the most total logs cut in the sawmill?

20) which weeks (1 to 28) saw the biggest log pond size!?

21) which weeks (1 to 28) saw the highest single-day number of logs cut in the sawmill?

22) which block saw the biggest change? in pond size, from the start of the block compared to the end?

23) which block saw the highest number of total logs cut at the sawmill?

24) which block saw the 2nd highest number of total logs added to the pond?

25) which block has the highest median number of logs added to the pond?

Data

Hint
Business"An overview of the steps you'd typically follow to address each of the questions:Total Number of Logs Added to the Pond:Sum the values from the column that records the number of logs added to the pond daily.Total Number of Logs Cut at the Sawmill:Sum the values from the column that tracks the number of logs cut each day at the sawmill.Maximum Log Pond Size:Find the maximum value from the ...

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.