Question: Please answer in excel Question 9 of 27 10 Points A study was conducted to determine the relationship of TV Ads expenses and Revenue of

Please answer in excel

Question 9 of 27 10 Points A study was conducted to determine the relationship of TV Ads expenses and Revenue of LAB Inc. The data for 12 months were obtained Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TV Ads (in Million 0.31 1.75 0.52 1.82 0.78 0.45 1,69 1.40 1.23 0 74 1.05 1 96 pesos Revenue(Million 8.3 22.8 13,5 21.2 15.3 126 20.7 19.7 16.2 13.3 15 5 25 4 pesos 1. Compute /and interpret. Determine the regression equation and interpret 3. Compute / and interpret. Estimate the revenue if the cost of TV ads is Php 1,850,000. Answer with text and/or attachments

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A small oven consists of a cubical box of dimension L = 0.1 m, as shown. The floor of the box consists of a heater that supplies P = 400 W. The remaining walls lose heat to the surroundings outside...

1 of 23 1.0 Points A company operates four machines during three shifts each day. From production records, the data in the table below were collected. At the .05 level of significance test to...

1 of 17 1.0 Points Q-Mart is interested in comparing its male and female customers. Q-Mart would like to know if the amount of money spent by its female charge customers differs, on average, from the...

i just want you checked my answers please fix them thank u An Internet media and market research firm measured the amount of time an individual spends viewing a specic Webpage. The data in the...

Ratio detective - which company corresponds to each industry and Why ? Bank, Departnent store, steel manufacturer, ad agency , grocey store and packaged goods manufacturer Asset Turnover Net Margin...

1 of 40 2.5 Points A researcher wants to check the claim that convicted burglars spend an average of 18.7 months in jail. She takes a random sample of 35 such cases from court files and finds that...

need help for Question 1 and 2 of the assignment fir ACCT 221 FORENSIC BUSINESS INVESTIGATION. Pertains to WorldCom scandal. QAssuming WorldCom was a company operating in Australia at the time of the...

1.0 Points Question 1 of 17 Two independent samples of sizes n1 = 50 and n2 = 50 are randomly selected from two populations to test the difference between the population means, distribution of the...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Help with C-F with work show. zoom in to see better. Excel File Edit View Insert Format Tools 43 64% (4) Thu 2:06 PM Q AutoSave OFF HESU- Data Window Help Advanced Accounting - Consolidation Case...

At the beginning of the current fiscal year, the balance sheet of Hughey, Inc., showed owners' equity of $520,000. During the year, liabilities increased by $21,000 to $234,000; paid-in capital...

Given are the FBS level of the residents during an outreach activity 98 94 132 129 121 85 97 125 138 124 126 126 89 135 97 126 110 135 135 122 123 115 105 128 126 110 130 108 120 108 105 130 108 147...

Current Attempt in Progress The master budget is a set of interrelated budgets that constitutes a plan of action for a specified time period. True False Attempts: 0 of 1 used

Using the utility formula below, which investment would you select if you were risk averse with A = 4? On the basis of the utility formula below, which investment would you select if you were risk...

Gather 5 materials that can be food, cleaning, toilet; then classify these materials into homogeneous or heterogeneous with some argumentation that gives meaning to the classification, record the...

Creams, liquid soaps and hair creams are used daily. Explain how these colloidal products are formed taking into account the states of aggregation of each of their phases.

One kilogram of water fills a 150-L rigid container at an initial pressure of 2 MPa. The container is then cooled to 40C. Determine the initial temperature and the final pressure of the water.

Case Study In 2008, when the subprime crisis hit the world economy, Dennis de Wet was working in the Isle of Man for a property syndication company that enabled investors to pool their money together...

6. Give three examples that nothing (doing nothing) can function as a cause.

2. To store it and

3. Give three examples from your own everyday life where a piece of communi-cation is structured into a linear sequence, i.e. B is the cause of A.