All that Glitter is Gold Your parents have received a lump sum payment of $1 million from their retirement fund. Being risk-averse individuals, your parents would like to invest at least one third of the money into precious metal such as gold. Their way of buying gold is to buy a physical gold bar from the bank and store it in their cupboard at home. Being a well-read individual, you advise them that those days of keeping physical gold is long gone and the trend now is to purchase ‘paper gold’. You explained to them that the ‘paper gold’ is also known as Gold ETF (exchange traded fund), which is a representation of physical gold that might be in a dematerialised or paper form, which gives an option to invest in gold online. These units are traded in exchange of a single stock of any company. Unlike physical gold, Gold ETF is a lot easier to invest because there is no fear of theft, storage or expenses like those in lockers or gold making charges. There are several Gold ETFs available in the market, with the more well-known ones such as SPDR Gold Shares, iShares Gold Trust and ETS Physical. Over a meal, you had some argument with your parents whom are sceptical about investing in Gold ETF, while you insist confidently that Gold ETF’s performance is the same as physical gold (spot gold), but with all the conveniences. Your sibling, Maryann, whom coincidentally works at a local jewellery shop sided with your parents’ argument and downloaded a set of historical spot gold prices and ETF prices for SPDR Gold Shares, and challenged you to prove that they are the same. The spot price is simply the price at which a commodity could be transacted and delivered on right now. The historical spot gold prices are provided in the denomination of per ounce basis, while the SPDR Gold Shares prices are in the denomination of per one-tenth ounce basis. Please use the Excel software and the data file “BUS105e_GBA_Data.xlsx” to answer the following questions.Question 1 Identify and describe the appropriate measures of location and dispersion. Interpret your preliminary observations to your parents, bearing in mind that they have not completed any formal education. Present the relevant information concisely and clearly for discussion. (15 marks) Question 2 (a) State the 95% confidence intervals of the Spot Gold and SPDR Gold ETF price, separately. From the interval, discuss whether your claim that Gold ETF’s performance is the same as physical gold (Spot Gold) is justified. (10 marks)(b) Discuss whether your conclusion from the question (a) above will change if you use a 99.99% confidence interval. What will your conclusion (at the 99.99% confidence level) be if the number of data for each set is a quarter of the original data set? Explain your findings. (6 marks) (c) How reliable is the verdict on your claim in 2(a)? (6 marks)Question 3 You have decided to use the classical hypothesis testing approach to test Maryann’s claim that the prices for SPDR Gold ETF and Spot Gold differs. You should include the following: (a) State the null and alternative hypotheses and explain how you develop these two (2) hypotheses. (5 marks) (b) Execute the hypothesis testing with ? = 0.01 using Excel. Present and list the test statistic you use for this test. Explain your decision criteria and inform the outcome to your parents. (15 marks) (c) Discuss the assumptions you have made in performing the hypothesis test? Are these assumptions reasonable for this case? Please provide explanation(s) to substantiate your view. (10 marks)Question 4 (a) Now that you have conducted a series of inferential statistics to validate your claim. Discuss any three (3) possible concerns in business or statistical aspects regarding the approach used here. Such that in retrospect, how would you have done this study differently again? . (18 marks) (b) Provide an executive summary of your analysis to your parents, including how this will affect your advisement to them on their investment decision, (15 marks)SFOR GOLD EFF Q. IOUNCE*GOLD PRICE I QUINCE*MEAN120. 10GEEMean1241. 20 BE`1Standard Error0. 205 5.07. 4 41Standard Error2.0940 0.8 3 2 2Median120. 6750.03Median1250. 299595Made115. 94.00 0 2Made1295Standard Deviation7. 28359 5 7 75Standard Deviation73. 85 6 4 7 7.95Sample Variance53.0507 8 20^Sample Variance5:454. 37.9342Kurtasis*0. 1 1 6 3 2 2 475Kurtasis0. 2 85 5 7497 5SKEWNESS-0. 4 4175 8357SKEWNESS-0. 193. 8.09495RENEE35. 25Range370. 1100. 5MiniMILITI1049.4MAKIMILITI135. 751415.5SLIMTI14.9412. 5851SLIMTI154 405 3. 55Count124^Count124^
SFOR GOLD EFF Q. IOUNCE* GOLD PRICE I QUINCE* MEAN 120. 10GEE Mean 1241. 20 BE`1 Standard Error 0. 205 5. 4 41 Standard Error 2.0940 0.8 3 2 2 Median…
Place Your Order
Frequently asked questions
Is your service confidential?
When you place an order with our company, we ask you to provide us with such personal information as your name, phone number, and email address. We need this data to keep you updated on the important things related to your order or account.
Is there a possibility of plagiarism in my completed order?
We complete each paper from scratch and in order to make you feel safe regarding its authenticity, we check it for plagiarism before its delivery. To do that, we use our in-house software, which can find not only copy-pasted fragments but even paraphrased pieces of text. Unlike popular plagiarism detection systems that are used by most universities (e.g. Turnitin.com), we do not report to any public databases—therefore, such checking is safe.
We provide a plagiarism-free guarantee that ensures your paper is always checked for its uniqueness.
Is there a money-back guarantee? If yes, how can I receive a refund?
You can certainly get your money back in several cases. You can receive a full refund if you have paid for your order twice or if you have placed two identical orders. In case your paper was late or the quality of the paper does not correspond to your expectations, you will get compensation for these issues.
Do you keep a database of pre-written essays?
No, we do not have such a database. All papers you order from us are written from scratch. This means your paper is unique and has never been published before—neither will it be published after we deliver it to you.
When will my custom paper be done?
While placing an order with WritersHub, you can choose a period of time within which a paper should be delivered to you. The countdown until the specified deadline starts automatically from the moment we receive your payment in our system. For example, if you pay for your order at 6pm on Monday and choose a 3-day delivery option, you will receive your custom paper by 6pm on Thursday.
Remember that a writer needs a sufficient amount of time in order to conduct thorough research. Therefore, please choose the most suitable deadline when you place an order. Moreover, the later you need your paper to be delivered to you, the cheaper it will be. Thus, you will be able to save your money while your writer will have enough time to work on your order and ensure its quality.
Make sure you upload all the additional materials at the very beginning. If you fail to do that, the deadline for your order will be postponed as well.
I haven’t received my custom paper by the deadline. What should I do?
Let us know immediately about that. You can do it by writing a message on Facebook or email us. Our support manager will carefully examine your order and will assist you with it right away. The reasons for late delivery may vary from time to time. It can happen that you have entered a wrong email address or your spam filter does not allow you to receive emails from us. It is also possible that the writer is waiting for your reply and can not continue working without your assistance, or we are checking the work for plagiarism. Whatever the case may be, contact us if you have any problems with getting your order on time.