Font size
WorksheetsPost-Test ISST305 ATT
Total questions: 100
Worksheet time: 3hrs 28mins
Analytics is the use of ___, ___, ___, ___, and ___. (Select two (2) answers that apply)
data, information technology, statistical analysis
data, database, and information
quantitative method, computer-based model
Where can you apply Analytics? (Select three (3) answers that apply))
Human Resource Planning
Chain Plant Regression
Pricing Decisions
Pharmacuetical Department
Financial and Marketing Activities
Analyzes the past performance and tell what is likely to happen.
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Uses optimization techniques in telling what might have happened and what is the best solution.
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Uses data to understand past & present.
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
What are the Two Types of Data Mining. (Select two (2) answers that apply))
Clustering Data Mining
Supervised Learning
Regression Data Mining
Unsupervised Learning
Which does NOT describe a Dependent T-test?
It is also known as Paired Sample Test.
It compares the median of the same group.
It compares the mean of the same group.
It compares data from different times.
Which is an assumption for a T-test?
There is a non-equal set of data.
The population is homogenous.
The distribution is normal.
The mean should be apart.
What is the first step in terms of statistical logic?
Recall the formula to be used.
State the alpha ( α ).
Define the hypotheses.
State the decision rule (t-value).
Which best describes a t-test?
It is a type of descriptive statistics.
It is used to determine if there are significant differences.
It can be used as long as the data is not normally distributed.
All of the above.
Which tells the probability of obtaining a result?
T - Value
P - Value
Standard Deviation
Mean
Which is a symbol for a null hypothesis?
H1
H2
Ha
Ho
Identify the scales of measurement
Number of calls receive per Agent.
Tim : 3
Lisa: 0
Barry: 6
Kevin: 9
nominal
ordinal
interval
ratio
Marital status is an example of what variable?
Quantitative variable
Qualitative variable
Which does not belong to the group?
Grade in Math
Gender
Religion
Nationality
How many paintings did the painter sell in March?
20
4
10
25
The pictograph shows the numbers of goals scored by four soccer teams in a season.
How many more goals did Shooters score than Raiders?
40
25
20
15
The pictograph shows the numbers of apples eaten by five friends.
How many apples did Sian and Vikram eat altogether?
2
3
5
7
The pictograph shows the monthly sales of three rival pizza companies.
During the month, how many more pizzas did Heaven's Pizza sell than Draught's Pizza?
1250
1375
1500
1625
The pictograph shows the earnings of four men in one week.
As well as whole notes representing $100, there can be quarter, half and three-quarter notes.
How much more did Donald earn than Bernie?
250
225
175
150
In 2008 approximately what percent of the world's population lived in Asia?
50%
60%
75%
90%
Anna did a survey where she asked all the children in her school to name their favorite pet. The results are shown in the pie chart. If there were 800 children in the school, how many said their favorite pet was Fish?
4
9
14
32
The bar graph shows the results when a die was thrown a number of times.
How many sixes were thrown?
2
3
5
6
The bar graph shows the favorite colors of 20 students in a class.
How many more of them favored orange than those who favored green?
1
3
4
5
The bar graph shows the usual method of transport to school for the students in a class.
How many students are there altogether in the class?
20
21
22
23
The bar graph shows the scores Brett obtained in his end of year exams.
How many more did Brett score in his best subject than in his worst subject?
25
35
45
60
The bar graph shows the scores Brett obtained in his end of year exams.
Luke's score in English was 15% higher than Brett's score in English.
What was Luke's score in English?
89
79
72
69
Jerry recorded the temperature in his room (in Degrees Fahrenheit) every two hours over a 12 hour period from noon to midnight. The results are shown in the line graph.
What was the approximate temperature in Jerry's room at 9 p.m.?
35°F
30°F
25°F
20°F
Jerry recorded the temperature in his room every two hours over a 12 hour period from noon to midnight. The results are shown in the line graph.
What was the difference between the highest and the lowest temperatures Jerry recorded?
25°F
30°F
35°F
40°F
The population of a town was recorded every twenty years from 1900 to 2000. The results are shown in the line graph.
What was the population of the town in the year 1900?
400
800
900
8000
The population of a town was recorded every twenty years from 1900 to 2000. The results are shown in the line graph.
By how much did the population increase between 1920 and 1980?
2800
3000
3800
4000
The population of a town was recorded every twenty years from 1900 to 2000. The results are shown in the line graph.
Assuming that the trend in the population growth continues, which of the following is most likely to be the population of the town in the year 2020?
6000
6400
6800
7400
You assign the students in your class a number and choose 6 numbers from a basket. What sampling method are you using?
Convenience
Systematic
Simple Random
Stratified
Systematic
Simple
Cluster
What is the purpose of a pivot table?
Create a Chart
Alphabetize Information
Summarize Data
Politicize Information
____ sign is used to create an absolute cell reference for MS Excel
@
&
=
$
What is the name of the chart?
Area Chart
Line Chart
Column Chart
Mekko Chart
What is the name of the chart?
Scatter Plot Chart
Bubble Chart
Line Chart
Waterfall Chart
Where is a Pivot Table inserted?
Below the last row of data in your worksheet.
Next to the last column of data in your worksheet.
It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.
When using Conditional Formatting, which technique will let you highlight the top three items in a column?
Use the Top 10 Items rule, but edit the number of items to three instead of 10.
Create a new rule to highlight the top three items in a column.
Highlight the top 10, but then manually format the bottom seven of those 10.
Use Conditional Formatting > Manage Rules
What does data validation allow you to do?
all of these answers
restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.)
check the accuracy of your unique Excel worksheet functions
lock cells to prevent others from editing them
From the business perspective, what is the most important characteristic of Big Data?
Volume
Veracity
Velocity
Variety
Value
The technologies for gathering, storing, analyzing, and providing access to data to help make better business decisions refers to ....
Business Intelligence
Data Warehousing
Cloud Computing
Business Analytics
Internet of Things
The scientific process of transforming data into insights for the purpose of making better decisions refers to ....
Business Intelligence
Data Warehousing
Cloud Computing
Business Analytics
Internet of Things
You need to immediately find out whether people are viewing the new content that you just added today. Which of the following would be most useful?
Landing Pages
Real-Time
Intelligence Alert
Annotations
Select the types of Datatypes. (Select three (3) answers that apply))
Linear
Discrete
Primary
Preliminary
Continuous
What is the syntax to output "Hello World" in R ?
'hello world'
"Hello World"
print("Hello world")
all of the above
how do we insert comment in R programming
# this is a comment
/* this is a comment
// this is a comment
none of these
R runs on the ____________ operating system.
Linux
Windows
Ubuntu
Any operating system
What will be the output of the following R code?
> x <- 6
> class(x)
“integer”
“numeric”
“real”
“imaginary”
R Basics
var_x <- 27L
cat(" Next the class of var_x becomes ",class(var_x),"\n")
The output will be
A decision tree is a _____ used to help managers make decisions.
scientific model
mathematical model
geographical model
super model
What does these 4 colour boxes on extreme right side called
Title
Legend
Heading
Label
What type of graph is this?
Bar graph
Box Plot
Histogram
Frequency Polygon
Which type of graph is show here
Polygon
Histogram
ScatterPlot
BoxPlot
Which of the following are direct benefits of Business Intelligence?
Options
Decision making
Delivers data mining functionality
Artificial intelligence
All of the above
________________ in business intelligence allows huge data and reports to be read in a single graphical interface
Warehouse
Reports
OLAP
Dashboard
Which of the following are BI tools?
Qlik
Siebel
Cognos
All of the above
How many types of BI users are there?
Four: The Professional Data Analyst, The IT users, The head of the company, The Business Users.
Two - The head of the company, The Business Users.
One- The Business Users
Three-The IT users, The head of the company, The Business Users.
bar chart
line chart
Column
pie
Which has a higher median?
Florida
Texas
What is Florida's median?
10
15
12
18
Identify which Data Visualization Technique is in the picture.
(a)
Identify which Data Visualization Technique is in the picture.
(a)
Identify which Data Visualization Technique is in the picture.
(a)
Identify which Predictive Analytical Modeling Techniques is in the picture.
(a)
Identify which Predictive Analytical Modeling Techniques is in the picture.
(a)
Identify which Predictive Analytical Modeling Techniques is in the picture.
(a)
Identify which Predictive Analytical Modeling Techniques is in the picture.
(a)
Identify which Predictive Analytical Modeling Techniques is in the picture.
(a)
Identify which Data Visualization Technique is in the picture.
(a)
Web analytics involves the collection, measurement, and analysis of website data.
What types of insights do web analytics tools provide for digital marketers?
(Select two (2) answers that apply)
Content performance
Names of website visitors
Call length from website phone numbers
Source of traffic
Google Analytics is the most commonly used analytics tool.
What are the benefits of using the standard version of Google Analytics?
(Select two (2) answers that apply)
Free of charge
Data sample is 100% accurate
Easy to implement and install
Unlimited customization
Marketers must comply with the various data protection regulations associated with web analytics.
When using analytics tools, what actions can you take to help ensure you are in compliance with EU data protection legislation?
(Select two (2) answers that apply)
Collect cookie data anonymously and share with companies outside of the EU
Share visitor data with third parties when visitor consent is implied
Have a clear policy on how the analytics data you collect is used and managed
Get explicit consent from the consumer when collecting PII
To use Google Analytics, you first need to install a piece of tracking code on your website.
What are the main ways to install Google Analytics code on a website?
(Select two (2) answers that apply)
Implement it using Google Tag Manager
Install it directly using Google Ad Manager
Implement it using Google Tag Assist
Ask a web developer to hard code it on every webpage
Marketers can gain a number of benefits by linking a Google Analytics account to other Google marketing tools.
What are some of those benefits?
(Select two (2) answers that apply)
Reduces the amount of data available
Increases the amount of data available
Makes evaluation of data unnecessary
Allows you assess the value of channels in more detail
In analytics, a goal can be defined as the number of times or the rate at which users take a desired action on your site, such as making a purchase or downloading a file.
Why is it important to set up and measure goals for any digital marketing campaign?
(Select two (2) answers that apply)
Allows marketers to tailor content to niche audiences
Encourages marketers to invest extra resources on poorly performing campaigns
Provides insight into which content is working well on a site
Helps determine if a campaign is commercially successful
You are setting up a funnel for a Destination goal in Google Analytics.
What area of the screen should you navigate to first?
Choose the correct area on the image shown.
1
2
3
4
The Audience tab in Google Analytics contains a number of different reports on the visitors that come to your website.
What types of insights can you develop on your website’s visitors using the Audience reports?
(Select two (2) answers that apply)
Affinity categories and interests
Education level and skills
Amount of disposable income
Language and location
When you integrate Google Ads with Google Analytics, you can uncover valuable information about your paid search activities.
What insights can you develop using the Google Ads report in Google Analytics?
(Select two (2) answers that apply)
Identify high-performing times of day
Learn about the devices visitors are using
Find information on click costs
Understand how visitors arrive at your site
You can use the Events reports in Google Analytics to develop insights into how users are interacting with your website and content.
What actions do you need to take before using the Events reports?
(Select two (2) answers that apply)
Configure the eventCategory and eventAction variables
Assign a unique 3-digit number to every item being tracked
Add additional code to any website elements you want to track
Link non-standard actions in Google Tag Manager
Event tracking is a useful feature in Google Analytics that helps you collect data about interactions with your content.
What types of actions can you track and monitor using the Events reports when they are set up in Google Analytics?
(Select two (2) answers that apply)
The number of times a video Play button is clicked
The number of times a brochure is downloaded
The number of cookies collected on a website
The number of times a custom report is modified
You would like to use the Intelligence Events feature in Google Analytics to alert you to traffic spikes on your website.
What part of the screen should you navigate to first?
Choose the correct area on the image shown.
1
2
3
4
5
Google Analytics can provide you with valuable data about the visitors to your website.
What are the best practices for ensuring that you track data effectively using Google Analytics?
(Select two (2) answers that apply)
Add analytics tracking code to every page and across all relevant domains and websites
Avoid using views that have no filters applied
Define your KPIs after you begin analyzing the campaign data
Use Internal IP filtering with Views to avoid skewing data reports
Data Mining is also referred to as. (Select two (2) answers that apply)
Exploratory Data Analysis
Knowledge discovery from Databases
None of the three
Survey Analysis
This is an example of ________________
Data inconsistency
Data redundancy
Data security
Data consistency
Numerical information that tell about “how often, how many, how often” in database called ...
Quantitative Data
Qualitative Data
Data Numeric
Data Histogram
The right 5 main steps of Data Analytic below is ...
Collecting - Cleaning - Processing - Analyzing - Visualizing
Cleaning - Collecting - Processing - Visualizing - Analyzing
Cleaning - Processing - Collecting - Analyzing - Visualizing
Collecting - Processing - Analyzing - Visualizing - Cleaning
Advanced computation skill that is required as Data Analyst are the following options, except ...
Microsoft Excel
SQL
Statistical Language (R & Phyton)
Machine Learning
Future challenge in Big Data Analaytic that we have to face for several years ahead is ....
Machine learning will keep same year by year
There is no change of Data scientists and CDOs (Chief Data Officer) in each company
Big Data Analytic promises to change the way businesses operate
Data volumes will not continue to increase and migrate to the cloud
______ is a process of extracting, manipulating, visualizing, maintaining data as well as generating predictions.
Data Science
Data Encryption
Data Transformation
Data Visualization
Which of these are the two types of qualitative data?. (Select two (2) answers that apply)
Nominal
Ordinal
Discrete
Continuous
Which of these are the skill required to be a data analyst. (Select multiple answers that apply)
Data Visualization
Machine Learning
Statistical Knowledge
Data Cleaning
Microsoft Excel
