Consider the data of the watermelon market provided in the accompanying Excel file

Consider the data of the watermelon market provided in the accompanying Excel file. Read the Data dictionary, which is accessible through the Excel file first tab.
Use the data provided to create two new variables containing the raw values of P and Q.
The data in the Excel file is provided in natural logs. You need to convert the relevant variables to their actual values. Excel’s EXP function does the inverse of the LN function, converting natural log numbers to raw numbers.
Plot separate line charts for P and Q, with time (in years) on the horizontal axis. Make sure to label your vertical axis appropriately.
Create a table with the following columns:
Column 1 (Q): Display arbitrary quantities, from 500 to 10,000, in intervals of 500.
Column 2 (LogQ): Convert the values of Q in Column 1 to natural log format.
Column 3 (LogP-supply): Compute the corresponding value of log P for the following supply function: log.
Please write a couple of points on how you calculated and created graph.
Please use Excel…….

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount