{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T03:45:23-04:00", "answer_date": "2024-06-28 03:45:23", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4234118", "url": "\/study-help\/questions\/question-1-a-university-lecturer-at-a-large-private-university-4234118", "question_creation_date_js": "2024-06-28T03:45:23-04:00", "question_creation_date": "Jun 28, 2024 03:45 AM", "meta_title": "[Solved] QUESTION 1 A university lecturer at a lar | SolutionInn", "meta_description": "Answer of - QUESTION 1 A university lecturer at a large private university took a random sample of 55 students from her first-year | SolutionInn", "meta_keywords": "question,1,university,lecturer,large,private,random,sample,55,students,first-year,business", "question_title_h1": "QUESTION 1 A university lecturer at a large private university took a random sample of 55 students from her first-year Business Data Analysis course.She wishes", "question_title": "QUESTION 1 A university lecturer at a large private university took a", "question_title_for_js_snippet": "QUESTION 1 A university lecturer at a large private university took a random sample of 55 students from her first year Business Data Analysis course She wishes to investigate the relation between the number of hours students spend on casual employment per week and marks attained in the most recent assessment item For each student, the number of hours worked per week and marks attained were recorded The data are stored in 'HoursMark55' worksheet in the xls data file attached In addition, students were also asked to respond to survey questions concerning other variables (e g major of study chosen, suburb where student lives, country of origin, etc) The lecturer categorised the data collected on the variable suburb where student lives into ten suburbs, and calculated the frequencies as presented in the table below Suburb Category Frequency Suburb A 3 Suburb B 9 Suburb C 7 Suburb D 6 Suburb E 8 Suburb F 7 Suburb G 5 Suburb H 5 Suburb I 2 Suburb J 3 Using the information presented in the table above, answer the following questions (a)Which graphical technique would you use for making comparison in the number of students in each suburb Explain your reasoning in selecting this graphical chart Using Excel, construct and present the chart (b)Which graphical technique would you use for making comparison of the proportion of the number of students in each suburb Explain your reasoning in selecting this graphical chart Using Excel, construct and present the chart QUESTION 2 The lecturer wishes to draw histograms in presenting graphical summaries of the data on the two main variables concerned weekly working hours and marks attained , as stored in 'HoursMark55' worksheet (a)She decided to use 7 class intervals to construct a histogram for each variable Explain how the lecturer could have decided in using 7 as the number of class intervals to be used (b)The lecturer specified class intervals 0 X 5, 5 X 10, , 30 X 35 for the weekly working hours variable She then specified class intervals 50 X 55, 55 X 60, , 80 X 85 for the marks attained variable Explain how the lecturer could have decided on the width of each class for these class intervals on each of the two variables (c)Using Excel, draw and display the histogram for the working hours variable using the class intervals specified in part (b) Comment on the shape of the distribution of the data set as displayed in the histogram (d)Using Excel, draw and display the histogram for the marks attained variable using the class intervals specified in part (b) Comment on the shape of the distribution of the data set as displayed in the histogram QUESTION 3 The lecturer would like to present numerical descriptive measures to summarize the data on the two variables weekly working hours and marks attained (a)Using the relevant Excel function, display a numerical summary report for each of the two variables including measures such as mean, median, mode, range, variance, standard deviation, smallest and largest values, and the three quartiles Also, calculate and display the coefficient of variation value for each of the two variables Notes Use QUARTILE EXC command to generate the three quartiles (b)Using the relevant Excel function, compute the correlation value of the relation between the working hours variable and the marks attained variable Display the correlation value Then, provide an interpretation of this correlation value in terms of the relationship between the two variables QUESTION 4 The lecturer uses a regression analysis to further evaluate the linear relationship between the two variables working hours per week and marks attained (a)Specify the dependent variable and the independent variable for this regression analysis Briefly explain the reasoning for your selection (b)Use an appropriate graphical technique to draw a diagram that evaluates the relationship between the two variables Display the diagram On the same diagram, fit a linear trend line including the equation and the coefficient of determination R 2 (c)Use Excel to estimate a simple linear regression model Display the Excel regression summary table and write the estimated linear equation Then, provide interpretation of the intercept and slope coefficient estimates of the linear model (d)Display the value of the coefficient of determination Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables QUESTION 5 A recording label entertainment promoter wishes to use linear regression analysis to predict the concert attendance of an established Korean pop band in their upcoming tour in 2021 He believes that the expected number of concert attendees is related and can be explained by the number of times that the band's songs have been downloaded in the social media Yearly data concerning the two variables are collected and stored in 'ConcertDownloads15' worksheet in the xls data file attached a)Based on the information provided above, specify the dependent variable and the independent variable for doing the regression analysis Briefly explain the reasoning for your selection 1 mark b)Using Excel, draw a chart to evaluate the number of concert attendance over time Display your chart and provide a brief comment on what you can observe from the chart 1 mark c)Using Excel, calculate the correlation value of the relationship between the two concerned variables Then, provide an interpretation of the correlation calculated in terms of the relationship between the two variables 1 mark d)Use Excel to estimate a simple linear regression model Display the Excel regression summary table and write the estimated linear equation Then, provide an interpretation of the slope coefficient estimate of the linear model e)Display the value of the coefficient of determination Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables QUESTION 6 Refer to the data stored in 'ExportImport' worksheet in the xls data file attached The data show Australia's exports and imports of services by selected regions in 2017 and 2018 a)Use Excel to draw an appropriate graphical technique to compare the value of Australia's exports of services (in $m) in 2017 and 2018, broken down by region of export destination Display your chart output Provide comments on the information you observe from the chart output b)Use Excel to draw an appropriate graphical technique to display the percentage value of Australia's imports of services (in ) in 2017, broken down by region of import origin Display your chart output Provide comments on the information you observe from the chart output ", "question_description": "

QUESTION 1<\/u><\/strong><\/p>

A university lecturer at a large private university took a random sample of 55 students from her first-year Business Data Analysis course.She wishes to investigate the relation between the number of hours <\/em><\/strong>students spend <\/em><\/strong>on casual employment <\/em><\/strong>per week and marks attained<\/em><\/strong> in the most recent assessment item.For each student, the number of hours worked per week and marks attained were recorded.The data are stored in 'HoursMark55' <\/strong>worksheet in the xls. data file attached.<\/p>

In addition, students were also asked to respond to survey questions concerning other variables (e.g. major of study chosen, suburb where student lives, country of origin, etc).<\/em>The lecturer categorised the data collected on the variable suburb where student lives<\/em> into ten suburbs, and calculated the frequencies as presented in the table below.<\/p>

<\/u><\/em><\/p>

Suburb<\/strong><\/p>

Category<\/strong><\/p>

Frequency <\/strong><\/p>

Suburb A<\/p>

3<\/p>

Suburb B<\/p>

9<\/p>

Suburb C<\/p>

7<\/p>

Suburb D<\/p>

6<\/p>

Suburb E<\/p>

8<\/p>

Suburb F<\/p>

7<\/p>

Suburb G<\/p>

5<\/p>

Suburb H<\/p>

5<\/p>

Suburb I<\/p>

2<\/p>

Suburb J<\/p>

3<\/p>

<\/u><\/p>

Using the information presented in the table above, answer the following questions. <\/p>

(a)Which graphical technique would you use for making comparison in the number of students in each suburb?Explain your reasoning in selecting this graphical chart.Using Excel, construct and present the chart.<\/p>

(b)Which graphical technique would you use for making comparison of the proportion of the number of students in each suburb? Explain your reasoning in selecting this graphical chart.Using Excel, construct and present the chart.<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

<\/p>

QUESTION 2 <\/u><\/strong><\/p>

The lecturer wishes to draw histograms in presenting graphical summaries of the data on the two main variables concerned - weekly working hours <\/em>and marks attained<\/em>, as stored in 'HoursMark55' <\/strong>worksheet.<\/p>

(a)She decided to use 7 class intervals to construct a histogram for each variable. Explain how the lecturer could have decided in using 7 as the number of class intervals to be used. <\/p>

<\/p>

(b)The lecturer specified class intervals 0 < X 5, 5 < X 10, ..., 30 < X 35 for the weekly working hours variable.She then specified class intervals 50 < X 55, 55 < X 60, ..., 80 < X 85 for the marks attained variable.Explain how the lecturer could have decided on the width of each class for these class intervals on each of the two variables.<\/p>

<\/p>

(c)Using Excel, draw and display the histogram for the working hours variable using the class intervals specified in part (b).Comment on the shape of the distribution of the data set as displayed in the histogram. <\/p>

(d)Using Excel, draw and display the histogram for the marks attained variable using the class intervals specified in part (b).Comment on the shape of the distribution of the data set as displayed in the histogram. <\/p>

<\/p>

<\/p>

<\/p>

QUESTION 3<\/u><\/strong><\/p>

The lecturer would like to present numerical descriptive measures to summarize the data on the two variables: weekly working hours <\/em>and marks attained<\/em>.<\/p>

(a)Using the relevant Excel function, display a numerical summary report for each of the two variables including measures such as mean, median, mode, range, variance, standard deviation, smallest and largest values, and the three quartiles.Also, calculate and display the coefficient of variation value for each of the two variables. <\/p>

Notes:<\/em><\/em><\/strong>Use QUARTILE.EXC command to generate the three quartiles.<\/em><\/p>

<\/p>

(b)Using the relevant Excel function, compute the correlation value of the relation between the working hours variable and the marks attained variable.Display the correlation value.Then, provide an interpretation of this correlation value in terms of the relationship between the two variables. <\/p>

<\/p>

QUESTION 4<\/u><\/strong><\/p>

The lecturer uses a regression analysis to further evaluate the linear relationship between the two variables - working hours <\/em>per week and marks attained<\/em>.<\/p>

(a)Specify the dependent variable and the independent variable for this regression analysis. Briefly explain the reasoning for your selection.<\/p>

<\/p>

(b)Use an appropriate graphical technique to draw a diagram that evaluates the relationship between the two variables.Display the diagram.On the same diagram, fit a linear trend line including the equation and the coefficient of determination R2<\/sup>. <\/p>

<\/p>

<\/p>

(c)Use Excel to estimate a simple linear regression model. Display the Excel regression summary table and write the estimated linear equation.Then, provide interpretation of the intercept and slope coefficient estimates of the linear model. <\/p>

<\/p>

(d)Display the value of the coefficient of determination.Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables. <\/p>

<\/strong><\/p>

<\/p>

QUESTION 5<\/u><\/strong><\/p>

<\/p>

A recording label\/entertainment promoter wishes to use linear regression analysis to predict the concert attendance of an established Korean-pop band in their upcoming tour in 2021.He believes that the expected number of concert attendees is related and can be explained by the number of times that the band's songs have been downloaded in the social media.Yearly data concerning the two variables are collected and stored in 'ConcertDownloads15' <\/strong>worksheet in the xls. data file attached.<\/p>

<\/p>

a)Based on the information provided above, specify the dependent variable and the independent variable for doing the regression analysis. Briefly explain the reasoning for your selection. 1 mark<\/p>

<\/p>

b)Using Excel, draw a chart to evaluate the number of concert attendance over time.Display your chart and provide a brief comment on what you can observe from the chart.1 mark<\/p>

<\/p>

c)Using Excel, calculate the correlation value of the relationship between the two concerned variables.Then, provide an interpretation of the correlation calculated in terms of the relationship between the two variables. <\/p>

1 mark<\/p>

d)Use Excel to estimate a simple linear regression model. Display the Excel regression summary table and write the estimated linear equation.Then, provide an interpretation of the slope coefficient estimate of the linear model. <\/p>

<\/p>

e)Display the value of the coefficient of determination.Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables. <\/p>

<\/p>

<\/p>

<\/p>

QUESTION 6_______<\/u><\/strong><\/p>

<\/p>

Refer to the data stored in 'ExportImport' <\/strong>worksheet in the .xls data file attached.The data show Australia's exports and imports of services by selected regions in 2017 and 2018.<\/p>

a)Use Excel to draw an appropriate graphical technique to compare the value of Australia's exports of services (in $m) in 2017 and 2018, broken down by region of export destination.Display your chart output.Provide comments on the information you observe from the chart output <\/p>

<\/p>

b)Use Excel to draw an appropriate graphical technique to display the percentage value of Australia's imports of services (in %) in 2017, broken down by region of import origin.Display your chart output.Provide comments on the information you observe from the chart output.<\/p>", "transcribed_text": "", "related_book": { "title": "Global Strategy", "isbn": "0357512367, 978-0357512364", "edition": "5th Edition", "authors": "Mike W. Peng", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/649592eaa157d_32303.jpg", "uri": "\/textbooks\/global-strategy-5th-edition-9780357512364", "see_more_uri": "" }, "free_related_book": { "isbn": "1998434354", "uri": "\/textbooks\/financial-fluency-your-journey-to-wealth-and-freedom-begins-today-1st-edition-978-1998434350-257735", "name": "Financial Fluency Your Journey To Wealth And Freedom Begins Today", "edition": "1st Edition" }, "question_posted": "2024-06-28 03:45:23", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/refer-to-exercise-165-predict-with-90-confidence-the-number", "description": "Refer to Exercise 16.5. Predict with 90% confidence the number of beers to be sold when the temperature is 75 degrees.", "stars": 3 }, { "url": "\/study-help\/psychology\/1-use-examples-and-analogies-to-relate-new-material-to-1984745", "description": "1. Use examples and analogies to relate new material to something you care about and understand well, such as sports, hobbies, or films.", "stars": 3 }, { "url": "\/1-do-you-see-any-problems-with-philip-austins-plan", "description": "1. Do you see any problems with Philip Austins plan for European expansion? Do you support his entrepreneurial approach to exporting? What should be the features of a more systematic approach to...", "stars": 3 }, { "url": "\/study-help\/questions\/mention-three-differences-on-the-civil-senivaes-of-british-accupied-9841547", "description": "Mention three differences on the civil senivaes of British accupied Indian and indeqendent Indiar.", "stars": 3 }, { "url": "\/study-help\/questions\/1-how-should-the-bank-evaluate-rusty-bucket-brewery-co-564627", "description": "1. How should the bank evaluate Rusty bucket Brewery Co. LLC's USD 750000 loan request? 2. which SBA program would the bank most likely use to fund the loan for Rusty BUcket Brewing Co.LLC ? 3....", "stars": 3 }, { "url": "\/study-help\/questions\/budget-variance-analysis-revenue-and-expenses-category-budgeted-amount-2175828", "description": "Budget Variance Analysis (Revenue and Expenses): Category Budgeted Amount ($) Actual Amount ($) Revenue 250,000 230,000 Expenses 180,000 170,000 Compute the variance for revenue and expenses.", "stars": 3 }, { "url": "\/study-help\/questions\/a-doublepipe-heat-exchanger-operating-in-the-parallelflow-mode-carries-1011306", "description": "A double-pipe heat exchanger operating in the parallel-flow mode carries glycerin in the inner pipe and water in the annular region. The glycerin enters the heat exchanger at 90C at a mass flow rate...", "stars": 3 }, { "url": "\/study-help\/questions\/8-your-father-who-is-a-manager-broke-his-arm-1003260", "description": "8. Your father who is a manager, broke his arm because he slipped and fell in a hotel room shower while on a business trip. Is your father entitled to workers' compensation benefits? 3. A. 5.", "stars": 3 }, { "url": "\/study-help\/questions\/spade-manufacturing-produces-surfboards-the-company-uses-a-normalcosting-system-1009547", "description": "Spade Manufacturing produces surfboards. The company uses a normal-costing system and allocates manufacturing overhead on the basis of direct manufacturing labor-hours. Most of the company's...", "stars": 3 }, { "url": "\/study-help\/questions\/telnex-corporation-maintains-its-internal-inventory-records-using-first-1002853", "description": "Telnex Corporation maintains its internal inventory records using first - in , first - out ( FIFO ) under a perpetual inventory system. The following information relates to its inventory during the...", "stars": 3 }, { "url": "\/study-help\/questions\/suppose-a-local-college-has-tasked-you-to-develop-a-1011324", "description": "Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/hi-i-uploaded-the-10-solutions-and-would-like-to-4234117", "next": "\/study-help\/questions\/please-help-on-january-1-2020-blunt-co-purchased-50000-4234119" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "QUESTION 1 A university lecturer at a large private university took a", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/question-1-a-university-lecturer-at-a-large-private-university-4234118" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } } }