essay代写 >
新西兰代写 essay > investigate if the price$/kgof oranges in winter代写
investigate if the price$/kgof oranges in winter代写
100%原创,高质量代写&Turnitin反剽窃检测24小时在线客服微信&QQ：273427
5. TTest:The market wants to investigate if the price$/kgof oranges in winter is less thanthe mean summer price for oranges. The current data will be used as a typical representation of the price$/kg.

Determine the mean, standard deviation and standard error for the price$/kgin winter of oranges in your sample. [2 marks]

The market has found that, on average, the price of oranges in summer is $5.50/kg. Based on this information carry out a ttest to see if the average price$/kgin winter is less than the summer price of $5.50. Mention any assumptions, include relevant hypotheses and report the result and conclusion in the conventional manner. [6 marks]
6. Obtain a scatterplot of the
Price$/kg and
Quantity sold (t/day). Think carefully about which variable should go on the vertical axis. Remember, it is the independent variable that goes on the horizontal axis (i.e. the xaxis). Make sure you label your axes properly and that your graph has an appropriate title.
[
3 marks]
7. Briefly describe the nature of the relationship between these two variables:
Price$/kg and
Quantity sold (t/day).(Hint: mention strength and direction).
[2 marks]
8. Use Excel to carry out a regression analysison two variables:
Price$/kg(independent variable) and
Quantity sold (t/day)(dependent variable).

Copy the output into your assignment and then use it to determine the answer to the following questions.[2 mark]

Write down the regression equation. [1 mark]

State the Rsquared value and the standard error and explain what they mean with respect to the data. [4 marks]

Write down the value of the gradient of the regression line and explain what it means in the context of this question. [3 marks]

Are the values for the constant and intercept (slope coefficient) significant in this case? Justify your answer using values from the output.[3marks]

Do you think this regression model is a good model? Justify your answer using the regression output.[3 marks]
9. Using the information obtained for your analyses write a short conclusion about what you found out about the relationship between the
Quantity sold (t/day)and
price$/kg, and how this relates to
seasonand the type of
produce.
[3 marks]
Use your random sample of 200 customersfrom the minor assignment. Your answers to the assignment tasks below are to be based on
your sample of 200 customers. Make sure you keep a safe copy of your sample, since you cannot use Random Sample Generator to reproduce the first sample. (If necessary, talk to your tutor about generating a new sample.)
Assignment Tasks
For each task below, you must submit all of the required printouts, graphs, tables and summaries required.
NB:Each graph and table should have a heading and each axis should have a label!!
1.
Introduction and Variable List:Give a brief introduction to your report, setting out the nature of the data.
[1 mark]
2.
Data: Provide a printout of the data in your sample, sorted in ascending order based onorder (ID)number.
[1 mark]
3.
Pivot Table:Prepare a contingency table (crossclassification) using the Pivot Table option in Excel that compares types of
produceand
season. You may use counts or percentages as the basis of comparison. Compare any similarities or differences in the types of
produce sold, betweensummer and winter.
[2 marks]
4.
Pivot Table:Prepare another contingency table that shows the
average (mean) price$/kgand
average (mean) Quantity sold (t/day), classified by
seasonand the type of
produce. Compare any similarities or differences between the
seasons with regard to prices, and quantity ofapples and oranges sold:
a) Which
seasonhas the highest
average (mean) price$/kgfor oranges, and which for apples?

Which season has the highest mean Quantity sold (t/day)for oranges, and which for apples? [4 marks]
5.
TTest:The market wants to investigate if the
price$/kgof oranges in winter is less thanthe mean summer price for oranges. The current data will be used as a typical representation of the
price$/kg.

Determine the mean, standard deviation and standard error for the price$/kgin winter of oranges in your sample. [2 marks]

The market has found that, on average, the price of oranges in summer is $5.50/kg. Based on this information carry out a ttest to see if the average price$/kgin winter is less than the summer price of $5.50. Mention any assumptions, include relevant hypotheses and report the result and conclusion in the conventional manner. [6 marks]
6. Obtain a scatterplot of the
Price$/kg and
Quantity sold (t/day). Think carefully about which variable should go on the vertical axis. Remember, it is the independent variable that goes on the horizontal axis (i.e. the xaxis). Make sure you label your axes properly and that your graph has an appropriate title.
[
3 marks]
7. Briefly describe the nature of the relationship between these two variables:
Price$/kg and
Quantity sold (t/day).(Hint: mention strength and direction).
[2 marks]
8. Use Excel to carry out a regression analysison two variables:
Price$/kg(independent variable) and
Quantity sold (t/day)(dependent variable).

Copy the output into your assignment and then use it to determine the answer to the following questions.[2 mark]

Write down the regression equation. [1 mark]

State the Rsquared value and the standard error and explain what they mean with respect to the data. [4 marks]

Write down the value of the gradient of the regression line and explain what it means in the context of this question. [3 marks]

Are the values for the constant and intercept (slope coefficient) significant in this case? Justify your answer using values from the output.[3marks]

Do you think this regression model is a good model? Justify your answer using the regression output.[3 marks]
9. Using the information obtained for your analyses write a short conclusion about what you found out about the relationship between the
Quantity sold (t/day)and
price$/kg, and how this relates to
seasonand the type of
produce.
[3 marks]