Question
Hi, Can someone please help me with these questions in excel? I have attached the link to the data file and the questions below -
Hi, Can someone please help me with these questions in excel? I have attached the link to the data file and the questions below -
Answer the following questions using the data provided in the Excel file in the link at the bottom.
1. A company is looking at multiple platforms for its past ad campaigns. The data corresponding to the target population on each platform is as given in the excel sheet, question 1.
a.Develop a joint probability table.
b.What is the probability that the ad was targeted at adults?
c.What is the probability that the ad was posted on Instagram?
d. Given that the ad was on Billboards, what is the probability that the ad was targeted
at children?
2.The newly launched Tesla Roadster has estimated to drive 400 miles on average on a single charge with a standard deviation of 20 miles. What is the probability that it will last a trip of 350 miles?
3.Using the data provided in the excel sheet, question 3, answer the following questions.
a. Is there a significant difference between the temperatures in Dallas and New York?
b. Is there a significant difference between the temperatures in Dallas and Los Angeles?
4. Using the data provided in the excel sheet, question 4, answer the following questions.
a. Which independent variable has the most significance for predicting wine quality?
b. Develop a multiple linear regression model for predicting wine quality.
5. Using the data provided in the excel sheet, question 5, calculate the confidence and lift ratio for the rule "If loss of taste, then sore throat.
Data file: https://gofile.io/d/Sm64r1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started