## Java, VB, .Net Assignment

Start answer to the above dot points

Finish answer

<标题> (a) Use EXCEL to draw a scatterplot of Sale Price ($1000s) vs Useable Floor Area (square metres). The file Shop data.xlsx that can be downloaded from the Assignments page contains shop floor area and selling price data for each of 25 local shops sold within the last 6 months.

EXCEL Instructions:

<标题>
Refer to Topic 9 in the Excel Booklet for instructions on how to obtain a scatterplot. Make sure that the title of your scatter diagram ends with your network ID (e.g. Sale Price vs Floor Area blosj001).

**JAVA,VB,NET assignment**

Finish answer

<标题> (b) Use EXCEL to add a trendline and display its equation and R-squared value. Interpret the value of the intercept, slope and coefficient of determination.

EXCEL Instructions:

Refer to Topic 9 in the Excel Booklet for instructions on how to add a trendline and display its equation and R-squared.

**JAVA,VB,NET assignment**

Finish answer

(c) Use the simple regression equation from part (b) to predict the selling price of a shop having a useable floor area of 87 square metres. Comment on the accuracy and reliability of that prediction, ensuring that you specifically mention the coefficient of determination.

<标题>
Start answer to Discussion questions 1(c)

**JAVA,VB,NET assignment**

<标题> (d) You are a bit uneasy about the wisdom of relying on the single predicted price calculated above, and seek advice from a statistician. She checks your calculations and advises you that, in this particular instance, a variation of $40 000 either way from your prediction would be reasonable. Use this advice to compute a price range, rounding off the upper and lower bounds to the nearest thousand dollars.

Start answer to Calculations for 1d)

<标题> Finish answer

<标题> 2. Offering healthy alternatives at Jessie’s Java(10 marks)

Jessica has become increasingly concerned by the high energy content (whether measured in kilojoules or kilocalories) of many of the foods served at Jessie’s Java. She has come across data from a recent survey that shows that there is a high proportion of overweight adults in Australia, and has resolved to enhance the offerings of healthy eating alternatives in the café.

Discussion questions for 2

Use EXCEL to obtain a 100% stacked column chart for the data from the contingency table below.

EXCEL Instructions:

Refer to Topic 6 in the Excel Booklet for instructions on how to obtain a 100% stacked column chart. Please make sure that the title of your chart ends with your network ID (e.g. Sex vs weight category blosj001).

Consider a person who has been randomly chosen from among these 400.

What is the probability that the person is overweight?

What is the probability that the person is overweight, given that they are female?

What is the probability that the person is female and overweight?

<标题>
Are ‘being female’ and ‘being overweight’ independent characteristics for these 400 adults? Explain your answer.

Female Male Total

Underweight 8 2 10

Normal 97 78 175

Overweight 85 130 215

<标题>
Total 190 210 400

Contingency table of weight versus sex.

Start answer to Calculations for 2

Finish answer

3. Understanding the competition.(20 marks)

Jessica is interested to know how her business is performing when compared to the local competition. In order to find out more, she has collected some data on other businesses in her area. (See Assignment 2 Excel file). Please read the appropriate Excel instruction file on how to prepare the necessary computer based results.

Analyse the data on the competition with particular emphasis on providing:

A descriptive statistics summary of the data

A histogram

A discussion on the shape and dispersion of the data, including any necessary supporting calculations

Start answer to 3a)

Finish answer

Jessica believes her average weekly sales for the past year are $13,000 per week. If further data collection finds the population of her competition’s sales is normally distributed with a standard deviation of $7,400 per week, what is the likely population mean of weekly sales? Could this information, or a close approximation of it, be discerned from the sample Jessica collected? Explain.

<标题>
Start answer to 3b)

Finish answer

<标题> A competitor has developed a Greek salad that is ‘to die for’. Determine the probability of the competitor reaching the top quartile of the local competition’s weekly sales figures if the population’s weekly average sales are $12,100 with a standard deviation of $7,400. Explain to Jessica what this may mean to her if this competitor currently ranks in the lower quartile of competitors.