Tutor profile: Joan H.
Subject: Microsoft Excel
What is an appropriate use of a secondary axis in a graph and how do I employ it?
A secondary access is a great option for comparing two dependent variables against the same independent when the two dependent variables are on different scales. For example, looking at the price of two different goods over time, if the price of one good range from $0-10 and the other ranges from $100-$110; by employing the secondary axis, the variation in both prices is much easier to see when set to appropriate scales. By selecting the second data set, right clicking, choosing the option 'format data series', and selecting the option 'axis', the option appears to set the selected variable to a secondary axis.
What supply-side and demand-side factors effect the price of an agricultural good, for example the price of corn?
Supply side factors could include but are not limited to weather, demand for substitutes such as soybeans, input cost such as land, transportation cost of inputs, aggregate supply, especially supply of imports. Demand-side factors could include aggregatedDemand, encompassing demand for ethanol, demand for corn meal and feed, demand for other corn products, and demand for export, as well as price of ethanol, price of corn feed, price of substitutes such as soybeans, subsidies, government mandates, and taxes
What is the effect of corruption on GDP growth rate across countries?
By examining a measure of corruption in addition to a number of other GDP impacting factors in an OLS linear regression model, we can quantify how governmental corruption affects GDP growth globally. An example model one might use to answer this question is as follows: GDP Growth Rate = B0 + B1 Corruption + B2 Education + B3 Population Density + B4 Labor Force Participation + B5 Government Expenditure + u
needs and Joan will reply soon.