ISC451 media math assignment
.docx
keyboard_arrow_up
School
University of Kentucky *
*We aren’t endorsed by this school
Course
351
Subject
Computer Science
Date
Dec 6, 2023
Type
docx
Pages
3
Uploaded by DrArtPorpoise39
ISC 451 Fall 2022
Media Math Assignment
30 points possible (Each question3 pts each)
Old school media first. Refer to the information below to answer questions 1-7. Be sure to show your work for each question – that’s part of the points.
U.S. TV HHs = 122,400,000
U.S. adults 18-34 = 76,100,000
U.S. adults 18-49 = 138,200,000
U.S. adults 25-54 = 102,867,000
HUT = 104,040,000 (85%)
: Commercial cost for programs listed (these aren’t real)
Station 19 = $97,449
Grey’s Anatomy = $186,026
Big Sky = $112,465
Young Sheldon = $160,698
United States of Al = $107,161
Ghosts = $90,315
How We Roll = $71,616
Bull = $89,981
Law & Order Encore = $100,987
Law & Order SVU = $108,236
Law & Order Organized Crime = $102,339
Masterchef Junior = $72,253
Call Me Kat = $113,181
Welcome to Flatch = $24,292
Walker = $21,326
Legacies = $25,432
1.
Calculate the Adults 18-49 CPM for Grey’s Anatomy. Total Cost/ Gross Impression/ 1000
Total Cost: $186,026
Rating: 0.0055
138,200,000*.0055= 760100
186,026/760100/1000= 244.74
CPM= $244.74 2.
Calculate the Adults 18-34 reach for Young Sheldon. Reach= GRP/ Frequency Rating: 0.32
3.
Assume that an advertiser ran one ad on Big Sky, one on Ghosts and one on Masterchef Junior. Calculate the GRPs for Adults 25-54. (Assume no duplicated reach) .44+.96+.58= 1.98
4.
Calculate the gross impressions for the same media buy as in #3.
102,867,000*0.00198= 203676.66
5.
Calculate the Cost Per Impression (CPI) for the schedule above.
$112,465+90,315+72,253= 275,033/2036766.6
CPI= $0.14
6.
Explain how the ratings for Adults 25-54 would have been determined. The rating is the percentage of adults ages 25-34 exposed at least once.
7.
Would the shares for these programs have been higher or lower than the listed ratings? Why?
This is because the number of people exposed would be greater than the average shares
and the ratings would be higher than the shares. Now moving to digital. Again, don’t forget to show your work!
UK buys a banner ad on the main Google search site. The university pays $17,242.50 for the ad; it receives 75,000 impressions, and 4,125 viewers click through to the application page. 150 actually apply.
8.
Calculate the click-through rate. # of clicks/impressions
4,125/75,000= 0.055
=5.5%
9.
Calculate the cost per click.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Q_5
arrow_forward
All part work:
Full explain this question 9 and 10 text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line .
arrow_forward
Requirements
List the needed requirements to estimate a population proportion
List the needed requirements to estimate a population mean
arrow_forward
Question 13 sum.Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
arrow_forward
Place Value with Whole Numbers I- Item 92009
Question 3 of 7
Each sentence below is about the number 315.
NEX
Drag each sentence to show whether it is true or not true,
V ERefe
315
calcu
CLEAR
目
v Language
ENGCISI
1 represents 1 ten.
3 is in the hundreds place.
1 is in the ones place.
5 represents 5 ones.
3 represents 300.
Not True
True
arrow_forward
please solve all please as they related I will upvote your answer
arrow_forward
OVERVIEW
Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI
is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2,
resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart
which displays BMI as a function of mass and height using contour lines or colors for different BMI
categories, and which may use other units of measurement (converted to metric units for the
calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value
as shown the following table:
BMI value
Category
Underweight
Normal
Overweight
Less than 18.5
18.5 to less than 25
25 to less than 30
30 or higher
Obese
A national study in some country to analyze the BMI of the people in the country is considered. In this
study, a set of cities is selected in the study and randomly specific number of persons are selected to
check the BMI category of…
arrow_forward
Need help on practice question
arrow_forward
PET ID
PET NAME
PET TYPE
PET AGE
OWNER
VISIT DATE
PROCEDURE
246
ROVER
DOG
12
SAM COOK
JAN 13/2002MAR 27/2002APR 02/2002
01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST
298
SPOT
DOG
2
TERRY KIM
JAN 21/2002MAR 10/2002
08 - TETANUS VACCINATION05 - HEART WORM TEST
341
MORRIS
CAT
4
SAM COOK
JAN 23/2001JAN 13/2002
01 - RABIES VACCINATION01 - RABIES VACCINATION
519
TWEEDY
BIRD
2
TERRY KIM
APR 30/2002APR 30/2002
20 - ANNUALCHECK UP12 - EYE WASH
The functional dependencies that I note are as follows:
Pet ID --> Pet Name, Pet Type, Pet Age, Owner
Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column
So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.
arrow_forward
Question 47
arrow_forward
Computer Science
In order to get more familiar with decision support systems, business intelligence, analytics, and knowledge management, I'd like you to do an Internet search to find an article either about a specific decision support system or a type of DSS that you find interesting. Read the article, and then once you've read it, provide a summary (1-3 paragraphs) of the content of the article and why you found it to be interesting. Make sure to include a link to the article in your post
arrow_forward
Ages
Number of students
Relative Frequency
15-18
8
%
19-22
10
%
23-26
5
%
27-30
9
%
31-34
4
%
35-38
3
%
arrow_forward
Geographical Information System
The table below shows the true and measured data coordinates from a set of 5 points for accuracy assessment. Calculate the RMSE based on these data.
Point
X True
X Data
Y True
Y Data
1
14
15
93
90
2
65
63
78
78
3
23
27
9
10
4
39
38
16
14
5
42
45
51
56
arrow_forward
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Glen Austin has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.
Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated
arrow_forward
Tairiq MinesError! Bookmark not defined. Tairiq Mines in Glen Austin has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.
1. Represent the above as a single Entity Relation model. Provide any assumptions necessaryto support your model
arrow_forward
Please help me with. I dont understand what to do
Make a university 2nd year type Essay: is an academic paper specifically examining a relevant topic. You are free to write on any relevant issue of the course subject. The suggested topics are: government policy on uniting efforts of the state, business, and society in a country of your choice in dealing with any of the following issues: eradicating poverty and hunger; providing for quality education, good health and well-being; gender equality; decent work and economic growth; sustainable cities and communities; peace, justice, and strong institutions; clean energy; industry, innovation and infrastructure; reducing inequality; climate action; clean water and sanitation; responsible consumption and production. The minimum number of references is six including two books and four academic journal articles (other than the articles required or recommended as the readings in the syllabus). Feel free to additionally refer to other sources of…
arrow_forward
3
DO NOT COPY FROM OTHER WEBSITES
Correct and detailed answer will be Upvoted else downvoted. Thank you!
arrow_forward
P_Id
P_Name
Gender
Age
1
Aqib
Male
25
2
Saima
Female
36
3
Fatima
Female
29
4
Nouman
Male
31
5
Muneeb
Male
40
6
Tariq
Male
38
7
Ikram
Male
26
8
Sadia
Female
27
D_Id
D_Fname
D_Lname
Salary
City
1
Laiba
Hafeez
50000
Rwp
2
Sameer
Khan
80000
Isb
3
Talib
Ali
62000
Isb
4
Saleem
Iqbal
77000
Multan
5
Tania
Abbas
85000
Lahore
6
Huda
Ahmad
68000
Rwp
Write SQL queries for the following.
Display details of those patients whose age is either 25 or 36 or 29 without using a comparison operator.
Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator.
Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator.
Display full name of doctors whose first name…
arrow_forward
The table below is how Magical Medical Place (MMP) keep track of the medication it givens to
patients and the doctors that prescribed the medication.
Doc ID Doc Name Pat Name Pat contact
321456 John
321457 Sarah
Medication
Price Quantity
Reggy
Samual
0861236548
Penicillin
R200
10
0796549872
Antibiatics
R400
20
Robafen Cough
Doxycycline
Penicillin
Antibiotics
Robafen Cough
R10
40
321459 Mary
321460 Linda
321461 John
321462 Robert
Susan
0116549875
R250
20
Reggy
0861236548
R200
10
0321789654
0987349165
R400
20
Queen
Junior
R10
25
3.1 In which normal form is the above table? Motivate your answer.
3.2 Identify a Primary Key and motivate why the identified attributes were chosen.
3.3 Provide all the dependencies of the given table.
3.4 Convert the table into the second normal form.
3.5 Convert the table into the third normal form.
3.6 Must is the purpose of Normalization?
3.7 Provide two(2) suggestions on how to improve the design of the table after they have
been restructured into third…
arrow_forward
Choose the best answer from following answers:C(x): x is taking CSE 105. M(x):x is a CSE major. ∀×(M(x)^C(x)) in English is a) Every student is a CSE major and they all are taking CSE 105b) Every CSE student is taking CSE 105c) None of the above
arrow_forward
QUESTION 1
The OMCA club operations
When members join OMCA health club, they pay a fee for a certain length of time. Most memberships are for 1 year, but memberships for short periods are available. Due to various promotions throughout the year, it is common for members to pay different amounts for the same length of membership. The club wants to e-mail reminders to members to ask them to renew their memberships one month before their memberships expire. Some members have been angry with staff when asked to renew at a much higher rate than their original membership contract. So, the club needs staff to keep track of the price paid so that the managers can override the regular prices with special prices when members are asked to renew. The system must keep track of these new prices so that renewals can be processed accurately. One of the problems in the health club industry is the high turnover rate of members. Although some members remain active for many years, about half of the…
arrow_forward
___ they chose to go this summer is not known by anyone.
a)When
b)Which
C) What
d) In which
E) Where
arrow_forward
PRACTICAL EXERCISE 1,5
NICKORO
From the data given in the table below, create a Pie Chart to show the
distribution of the total amount amongst the various salesmen.
ABC Company Sales Performance Report
Salesman
Qtrl
Qtr2
Qtr3
Qtr4
Total
3
Albert
148
171
140
615
Carl
122
131
153
118
524
Cornell
211
243
Edwin
92
218
689
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Related Questions
- Q_5arrow_forwardAll part work: Full explain this question 9 and 10 text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line .arrow_forwardRequirements List the needed requirements to estimate a population proportion List the needed requirements to estimate a population meanarrow_forward
- Question 13 sum.Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this linearrow_forwardPlace Value with Whole Numbers I- Item 92009 Question 3 of 7 Each sentence below is about the number 315. NEX Drag each sentence to show whether it is true or not true, V ERefe 315 calcu CLEAR 目 v Language ENGCISI 1 represents 1 ten. 3 is in the hundreds place. 1 is in the ones place. 5 represents 5 ones. 3 represents 300. Not True Truearrow_forwardplease solve all please as they related I will upvote your answerarrow_forward
- OVERVIEW Body mass index (BMI) is a value derived from the mass (weight) and height of a person. The BMI is defined as the body mass divided by the square of the body height, and is expressed in units of kg/m2, resulting from mass in kilograms and height in meters. The BMI may be determined using a table or chart which displays BMI as a function of mass and height using contour lines or colors for different BMI categories, and which may use other units of measurement (converted to metric units for the calculation). The BMI is a convenient way for classifying persons in to 4 categories based the BMI value as shown the following table: BMI value Category Underweight Normal Overweight Less than 18.5 18.5 to less than 25 25 to less than 30 30 or higher Obese A national study in some country to analyze the BMI of the people in the country is considered. In this study, a set of cities is selected in the study and randomly specific number of persons are selected to check the BMI category of…arrow_forwardNeed help on practice questionarrow_forwardPET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.arrow_forward
- Question 47arrow_forwardComputer Science In order to get more familiar with decision support systems, business intelligence, analytics, and knowledge management, I'd like you to do an Internet search to find an article either about a specific decision support system or a type of DSS that you find interesting. Read the article, and then once you've read it, provide a summary (1-3 paragraphs) of the content of the article and why you found it to be interesting. Make sure to include a link to the article in your postarrow_forwardAges Number of students Relative Frequency 15-18 8 % 19-22 10 % 23-26 5 % 27-30 9 % 31-34 4 % 35-38 3 %arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L