Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting. In the same worksheet in part (c) dynamically apply the following formats for Qtr1 and Qtr4 for all related revenue types: i. Values over $140,000 should be yellow. [2] ii. Values under or equals to $80,000 should be read and bolded   Thom-Pierre Consultants (TPC)       Quarterly Schedule of Revenue         For the year December 31, 2018                       QTR1 QTR2 QTR3 QTR4 2018 Sales 290000 320000 320000 490000   Interest 102500 175000 180000 54000   Investment Income 13000 9500 10000 20000   Other 16000 25000 19500

Q: For each of the following logical tests indicate whether an IF function in excel would return a…

A: Let discuss the IF statement in brief- =IF(expression , value_if_true , value_if_false) In IF…

Q: Using the table below, write an appropriate relational algebra satisfying the following requirement…

A: 1) σtype="Lamp" (Product) 2) σtype="Lamp" and Price< 10.0 (Product)

Q: The following examples show how arithmetic operators-especially / and %–work with integral data…

A: Arithmetic Expression Result Description 2+5 7 Addition of an int with int is an int 13+89.0…

Q: A sample dataset has been provided to you in the '/data/dataset.csv' path. Here are the attributes…

A: Code:   def calculate( dataFile, col_num): """ Input Parameters: dataFile: The dataset file.…

Q: In cell C19, insert a formula that will calculate the projected advertising spending after the…

A: Please find the answer in the following steps.

Q: Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded,…

A: Use the following formula: =COUNTIF(range,"*txt*") =COUNTIF(C2:C11,"*ON*")

Q: 6( The HR Department wants to display all the employees who were hired either on 01-JAN-2021 or…

A: The Correct answer is c i.e. SELECT * FROM employees WHERE hire_date IN ('01-JAN-2021', '31-…

Q: Convert the NFA N below to a DFA D = (Q', E, 8', q' , F') using the approach from Lecture 7 and…

A:

Q: Exercise 3 1 Enter the following command M=magic(5) Using a MATLAB function, get the maximum value…

A: After entering command it M=magic(5) them M is a matrix storing 25 elements of size 5X5  and matrix…

Q: ier a dataset for [C1, The features are given by F1, F2 and F3. Each of these features have two…

A:

Q: Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula…

A: Given: Lael wants to figure out how many totals and averages there are for active pupils.To count…

Q: Organize the following functions into six groups (labeled 1 to 6). Items in the same group should…

A:

Q: Program the following. Consider the data set given below. Map the data in array.…

A: As per Bartleby guideline, "Since you have asked multiple question, we will solve the first question…

Q: IN SCALA COULD YOU COMPLETE THE FUNCTIONS: get_january_data, get_first_price, get_prices,…

A: Coded using Scala.

Q: In cell N3, enter a formula using the IF function and structured references as follows to determine…

A: The solution for the above-given question is given below:

Q: 12. Consider this excel sheet to write the accurate function with full syntax that counts how many…

A: Given data: The function that counts how many times any salesperson exceeded a sales quota for Q2…

Q: In which of the following scenarios is it appropriate to apply a named range? a. When using -COUNTIF…

A: Answer in step2

Q: Q2. After the successful conduct of Mid Term Examinations, the HOD of the Department of Examinations…

A: In C++ Program #include<iostream>#include<string.h>using namespace std; class student{…

Q: 5)ln cell G9, write a formula to determine if any of the bidders has a True value for Rule 1. Copy…

A: Note: As you have asked multiple questions, as per our policy we will solve the first question for…

Q: C2. Prepare a Decision Table for the Airfare Discount problem. Also write the total number of…

A: Decision tree: A decision table is a tool used in management of  testing and requirements. It is a…

Q: mxn (user-defined) factorial matrix using the Rand () function. Make sure the Rand () function is…

A: code ; #include <stdio.h>#include <math.h>#include<stdlib.h>int fact( int m ) //…

Q: In column C, write the formula for the required statistical tools numbered 1 Range to 15. Kurtosis…

A: In questions with many questions we must do the first three.

Q: formula to calculate the sum of the current assets i

A: SUM formula in Excel The SUM function is of the arithmetic formula used in Excel to compute sum(or…

Q: Given Table 1.0 below, it shows the various type of sources to generate electric power. You are…

A: ANSWER:-

Q: A: obtain the name and credit limit of the customer whose number currently is stored in…

A: SQL is a computer language stands for Structured Query language.Which is used for operating…

Q: 17. Selecting a data type involves which of the following? a. Maximize storage space b. Represent…

A:

Q: How do single-row functions work? Differentiate the different forms of single-row functions from…

A: Step 1  The answer is given in the below step

Q: how do i do this? in cell e2 enter a formula using the hlookup function as follows to determine a…

A: The Answer is

Q: Write a function called divide_dataset_into_training_and_testing as shown below that aims to split…

A: Splitting of data can be done using slice operation on data Frame for example,  dataset[:10] gives…

Q: 1a. It is known that x and n are integers, where x has a value of -1 and n has a value of 5. What is…

A: 1a ) Given expression  !(++x || n) + 6 - (!n && n * (n < n))

Q: A matrix for rugby results shows the number of conversions, drop goals and penalties for three teams…

A: Question given: A matrix of size (3,3) stores number of conversion, drop goals and penalty by 3…

Q: The InstantRide User Satisfaction team requires the average and maximum number of rides users have…

A: Derived Table : SELECT            USER_ID, COUNT(TRAVEL_ID) AS CNTFROM            TRAVELSGROUP BY…

Q: Pandas groupby function usually works along with each of the following aggregate functions except

A: Pandas groupby function usually works along with aggregate function is  count() sum() max() min()…

Q: Transform the wff below into clause form. For each step required give a brief description of the…

A: solve it with proper steps:…

Q: In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY…

A: Group by - To create a grouping for expressions or columns specified within a GROUP BY clause in one…

Q: Which of the following is an example of group function? a. UPPER b. COUNT c. CONCAT d. TRIM

A: Group functions are built-in SQL functions that operate on groups of rows and return one value for…

Q: Which function to be used to calculate the total customers who are above 35 years of age and earning…

A: a. countif() and c. sumif() cannot be correct because they both check single conditions only . and…

Q: Write a procedure in PL/I that gives information about undergraduate alumni for a university's…

A: This is a simple data processing routine which contains some interesting format specifications. In…

Q: Question 6 of 20: Select the best answer for the question. 3 5 6. Evaluate the determinant for the…

A: EXPLANATION: In linear algebra, determinants and matrices are used to solve linear equations by…

Q: From the images below, please provide the result of statement c. Select * from dept; Select * from…

A: Right join returns all rows from right table, even if there is no match. If there is a match in left…

Q: Let Tran1,Tran2 & Tran3 be three independent transactions. Where Tran1 transfers the one fourth of…

A: Given three transactions Tran1 , Tran2, Tran3. Tran1 is 1/4th of A account fund transfer to B…

Q: After the successful conduct of Mid Term Examinations, the HOD of the Department of Examinations has…

A: #include<iostream>#include<conio.h>using namespace std;int main(){    int…

Q: Which of the following is an example of group function? a. UPPER b. CONCAT c. COUNT d. TRIM

A: In step 2, you will get the answer.

Q: After the successful conduct of Mid Term Examinations, the HOD of the Department of Examinations has…

A: Program description: marks is a user input integer variable that stores the marks of a student. If…

Q: i want 4 SEQUENCES DIAGRAM from this use case:- OKI 옷 Student incorrect admin hội include add course…

A: Sequence diagram for Add course use case No of external entities: 1. Student 2. Database 3. System…

Q: The following statement tells the decomposition of the people survived a.k.a column Survived as of 0…

A: df_sex = data1_training_data    //You take your dataset as input. I don't know your dataset name…

Q: QUESTION 1 Let A, B, and C be three sets. Select the right statement. (A – B ) U (A – C ) = O 1. AU…

A: option 3 is answer

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.