Calculate the mean and standard deviation for each state

Assignment Help Applied Statistics

Reference no: EM132212247

Assignment Questions -

Question 1 - Visit the Australian Stock Exchange website, and from "Prices and research" drop-down menu, select "Company information". Type in the ASX code "NAB" (National Australia Bank), and find out details about the company. Also, type in the ASX code "WBC" (Westpac Banking Corporation), and find out the details about that company. Information available in the ASX website will be inadequate for your purpose; you will need to search the internet for more information. Your task will be to get the opening prices of NAB and WBC shares for every quarter from January 2009 to December 2017 (unadjusted prices). If you are retrieving the monthly prices, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2009 to 2017 (Total 36 observations). After you have researched share prices, answer the following questions:

(a) List all the quarterly opening price values in two tables, one for NAB and the other for WBC. Then construct a stem-and-leaf display with one stem value in the middle, and NAB leaves on the right side and WBC leaves on the left side. (Must use EXCEL or similar for the plot.)

(b) Construct a relative frequency histogram for NAB and a frequency polygon for WBC on the same graph with equal class widths, the first class being "$14 to less than $16". Use two different colours for NAB and WBC. Graph must be done in EXCEL or similar software.

(c) Draw a bar chart of market capitals (or total assets) in 2017 (in million Australian dollars) of 6 companies listed in ASX that trade in similar products or do similar business as NAB or WBC with at least AUD50 million in market capital. Graphs must be done in EXCEL or with similar software.

(d) If one wishes to invest in NAB or WBC, what is the market recommendation (for example, from Morningstar, Fatprophets, InvestSmart, etc.)? If you cannot find the information, what would be your recommendation based on your research of these two companies (trend, P/E ratio, dividend yield, debt and Beta)?

Question 2 - The table below lists the new motor vehicles sales between January 2016 and December 2016 in 8 Australian states.

New motor vehicles sales by State between Jan 2016 and Dec 2017
Month	State
Month	NSW	VIC	QLD	SA	WA	TAS	NT	ACT
Jan-2016	28392	22426	17193	5208	7861	1298	626	1509
Feb-2016	32633	26782	18711	5988	8725	1319	851	1528
Mar-2016	35963	27716	21470	6087	9054	1515	1023	1550
Apr-2016	29391	23963	17753	5174	7601	1313	969	1563
May-2016	32867	26125	19565	5949	7935	1503	1180	1560
Jun-2016	43449	34262	27270	7613	10749	1853	1240	1542
Jul-2016	30219	25517	18445	5210	8234	1389	831	1524
Aug-2016	31788	27096	18062	5785	8144	1743	881	1519
Sep-2016	34424	28766	19702	6551	8668	2074	880	1531
Oct-2016	31850	27546	16870	5450	7580	1937	713	1552
Nov-2016	32955	28991	18733	6259	7657	1903	808	1570
Dec-2016	33632	27065	19252	6464	8026	1918	734	1573

From the information provided in the table above,

(a) Calculate the mean and standard deviation for each state.

(b) Calculate the Minimum, Q1, Median, Q3 and Maximum values for each state.

(c) Draw a box and whisker plot for the number of new vehicles sales of each state and put them side by side on one graph with the same scale for comparison. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)

(d) Discuss the number of new vehicles sales of each state, and the trends in new vehicles sales in different Australian states.

Question 3 - The Table below is taken from the Australian Bureau of Statistics (ABS) website. It provides data on Australian households with internet access at home from the Household Use of Information Technology Survey.

Table 1 - Households with internet access at home - 2008-09 to 2016-17
	Households with internet access
	2008-09	2010-11	2012-13	2014-15	2016-17
	'000	'000	'000	'000	'000
State or territory
New South Wales	1,890.2	2,163.6	2,274.5	2.407.9	2,439.9
Victoria	1,468.6	1.683.5	1,830.6	1,934.2	2,008.2
Queensland	1,182.1	1,347.3	1,517.0	1,552.4	1,591.9
South Australia	431.8	496.5	554.0	565.1	575.5
Western Australia	626.1	714.0	814.8	843.6	859.7
Tasmania	125.7	146.2	164.6	172.0	177.7
Northern Territory	45.5	50.7	58.8	58.1	57.6
Australian Capital Territory	108.2	121.8	128.9	137.2	140.1

From the information provided in the table above,

(a) What is the probability that a randomly selected household lives in Victoria?

(b) What is the probability that a randomly selected household lives in Tasmania and has an internet access in the year 2010-11?

(c) Given that a household has an internet access in 2012-13, what is the probability that a randomly selected household lives in New South Wales?

(d) What is the probability that a randomly selected household has an internet access in 2010-11 or 2012-13?

Question 4 - (a) In a study conducted by a bus transportation company, the average time of bus arrival at the central station is normally distributed, with a mean of 73 minutes and a standard deviation of 8 minutes. What value does the upper 5% of the time exceed?

(b) The Bureau of Meteorology found that the air temperature varies uniformly between 12 degree Celsius and 25 degree Celsius. What is the probability that the air temperature will be less than 21 degree Celsius?

(c) A marketing company is conducting an experiment in which participants are to taste one of two different brands of coffee. Their task is to correctly identify the brand tasted. A random sample of 200 participants is taken and it is assumed that the participants have no ability to distinguish between the two brands.

(i) What is the probability that the sample percentage of correct identifications is greater than 65?

(ii) What is the probability that the sample will have between 50% and 60% of the identifications correct?

Question 5 - (a) A survey conducted by a pharmaceutical company found that the probability of success in the clinical trial is 0.70. Suppose five hundred clinical trials are performed in the study, what is the probability of succeeding in the clinical trial between 280 and 355 times? Use normal approximation of the binomial distribution.

(b) A travel agency acts as a selling agent for a major airline company. The agency found that 210 out of 500 travellers cancelled their airline bookings after they had selected their flight details. At 0.01 level of significance, is there evidence that the population proportion of travellers who select their flights and cancel their bookings is less than 0.50?

(c) An internet service provider wants to estimate the mean amount of time that customers spend browsing web sites on daily basis. Find the 95% confidence interval estimate of the mean given the following random sample (in minutes) of 110, 123, 80, 131, 105, 65, 84, 118, 95.

Attachment:- Assignment File.rar

Reference no: EM132212247

Questions Cloud

Calculate the return on total investment : Stale-Mart is an established chain of more than 100 department stores. Joan Chris is the district manager of eight stores in the Denver area.

Discuss about the components of the net pension cost : Under both U.A.A P and IFRS we report all changes in the obligation in the value of plan assets as they occur. The ways the changes are determined and reported.

Calculate valuation using the terminal valuation method : Calculate valuation using the terminal valuation method. How to calculate? Calculate valuation using the anticipated ROI method, both before the money.

Prepare a contribution format income statement : Assume that the company produces and sells 95,000 units during the year at a selling price of $9.45 per unit. Prepare a contribution format income statement.

Calculate the mean and standard deviation for each state : The table below lists the new motor vehicles sales between January 2016 and December 2016. Calculate the mean and standard deviation for each state

Post the april transactions to the t-accounts : Post the April transactions to the T-accounts and compute the balance in the accounts at the end of April.(Round your answers to 2 decimal places.)

Create stakeholder matrix : Create a stakeholder matrix that classifies the stakeholders into one of the 4 quadrants.

The ability to build trusting and long lasting relationship : The ability to build trusting and long lasting relationship with project stakeholders is one of the key ingredients to becoming a successful project manager

What lifestyle changes have adults made : What lifestyle changes have adults made in recent decades that have improved outcomes with preventable conditions? Provide five examples of characteristics.

Reviews

len2212247

1/10/2019 2:35:02 AM

Assessment criteria - This assignment must be typed, word-processed or clearly hand-written (but plots and graphs must be done using EXCEL or equivalent software), and submitted online as a single file through Moodle. Important note: The file size must not be over 100MB. Microsoft Excel allows students to cut and paste information easily into Microsoft Word documents. Word also allows the use of Microsoft Equation Editor to produce all necessary formulae (use of these are recommended). It is expected that Excel would be used to assist in statistical calculations for questions in this assignment. Where Excel is used, use copy function, “Snipping tool” or similar to cut and paste relevant parts of the spreadsheet to verify that you have done the work. (In that case there is no need to write the equations.)

1/10/2019 2:34:55 AM

For those questions where Excel is not used to do the computations, all formulae and working must be included to obtain full marks. Only one file will be accepted in any of the formats mentioned above. No zipped file or any other file extension will be accepted. There will be late submission penalty for submissions beyond the deadline unless prior approval is obtained from the Unit Coordinator through the extension system in Moodle. Under no circumstances any submission that is late beyond 14 days from the deadline of Friday of Week 10 will be marked, or get any score other than zero.

1/10/2019 2:34:48 AM

Assignment markers will be looking for answers which - demonstrate the student’s ability to interpret and apply the statistical techniques in the scenarios and use statistical techniques as decision making tools in the business environment. Full marks will not be awarded to answers which simply demonstrate statistical procedures without comment, interpretation or discussion (as directed in the questions).

Write a Review

Required(*) Message

User Account

All Pages