Q1. A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid- 19 lockdown the respective shops recorded sales as follows: High Street Branch Quarter Q1 Q2 Q3 Q4 Sales 42,000 52,000 46,000 50,000 48,000 | 50,000 58,000 60,000 49,000 58,000 51,000 61,000 Mall Branch Quarter Q1 Q2 Q3 Q4 Sales 57,000 70,000 67,000 72,000 63,000 60,000 67,000 72,000 65,000 | 62,000 69,000 75,000 As a programmer hired by the shops' owner, write a java program to calculate: (a) the monthly combine sales figures for both shops; (b) the respective shops annual sales figures; (c) the grand annual combine total sales figures. Note: Your program must be implemented with arrays.
Q: Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name…
A: GIVEN:
Q: In a city there is a mini market called B-Mart that sells various types of snack. Specified min_sup…
A:
Q: Q5\Data recorded in table below by observing the activity of a single customer line during an…
A: Traffic engineering is that phase of engineering that deals with the planning, geometric design and…
Q: R programming 7. The associated R function is dlogis (x, location = 0, scale = 1) is for _________…
A: Question 7. The associated R function is dlogis (x, location = 0, scale = 1) is for _________…
Q: Q1. A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid- 19…
A: The answer is given below:-
Q: 14.Explain the characteristics of customers that have the following RFM scores: {11 5}, {1 5 1}, {5…
A: RFM analysis is a marketing technique used to quantitatively rank and group customers based on the…
Q: Consider that min and max value of attribute price are 3000 and 5000 respectively and the range is…
A: The Given data is min and max value of the attribute price are 3000 and 5000 the range is [ 0.5 -…
Q: You make a contingency table that compares if a person made a purchase and if they were exposed to…
A: As per our guidelines we are suppose to answer only first question. Post the remaining question as…
Q: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown…
A: Answers of parts a to e are given below showing the forecast, MAD and MAPE for 4-year moving…
Q: What are the SQL query commands to create the COURSE table (attached) with appropriate attributes…
A: Query to create a “COURSE” table:CREATE TABLE COURSE (COURSE_TYPE VARCHAR (20) NOT NULL UNIQUE,…
Q: Co has five salespersons who sell three different types of durian n records for each type of the…
A: #include <stdio.h> int main() { char name[5][10]={"Johari","Ah…
Q: A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid19 lockdown the…
A: public class MyClass { public static void main(String args[]) { //We can also use single…
Q: b) Write the pseudocode of Map and Reduce functions in Hadoop MapReduce philosophy to find average…
A: Given: Write the pseudocode of Map and Reduce functions in Hadoop MapReduce philosophy to find…
Q: stered bar chart to examine the method of payment by customer type A chart to examine whether the…
A: We find that we have 70 promotional customers and 30 daily customers in our results. For daily…
Q: Normalize the following table, given 1NF, 2NF and BCNF: Made By1 Made By2 Made In To Process Comp…
A: Find the answer given as below:
Q: Find those job categories whose maximum salary among the people hired after 1980 is more than 2500…
A: 1)To find those job categories whose maximum salary among the people hired after 1980 is more than…
Q: In [7]: def cost_function(x, y, theta): m - len(y) y_pred - x.dot(theta) (y_pred - y) ** 2 error =…
A: numpy module doesn't have a method named one() So, that is the reason why you are receiving that…
Q: A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid19 lockdown the…
A: “Since you have posted a question with multiple sub-parts, we will solve first two subparts for you.…
Q: From the sale records of XYZ Groceries, Mr. Francis wants to find out the most frequent items, and…
A: A set of items is called frequent if it satisfies a minimum threshold value for support and…
Q: 1. The following data records cigarette smoking and death rates due to leukemia in 14 states. We…
A: 1. Enter the given data about cigarette smoke and death rate due to Leukemia in Excel sheet 2.…
Q: Question #6 The number of ATM transactions per day was recorded at 15 locations in a large city. The…
A: (a) To find the median, first, arrange the data in ascending order. 30, 32, 35, 40, 47, 48, 49, 50,…
Q: exactly onenone of the following
A: Tourism in the Philippines follows its beginnings during the old times when the principal set of…
Q: Problem 18-28 (Algo) The following are historical demand data: ACTUAL DEMAND YEAR SEASON Spring…
A: Answer: Forecast for summer 2013 =340 Steps and excel workings: Calculate the values required to…
Q: Suppose the cover price of a book is $24.95, but bookstores get a 40% discount. Shipping costs $3…
A: Algorithm: Start Set totalUnits=60 Set perbookPrice=24.95 Compute: totalbookPrice=…
Q: The spreadsheet model for Sam’s Bookstore contains a two-way data table for profit versus order…
A: Sam’s Bookstore places orders in different locations of United States. The spread sheet of model for…
Q: Consider the following tables containing sales information: Sales Location LociD City Well Nets Auck…
A: Here we apply cross tabular and make tables:…
Q: The sales in a store are normally distributed with a mean of $10,000 and a standard deviation of…
A:
Q: QUESTION 4: In a plant, forklifts are used to deliver the materials between the departments. The…
A: Answer: I have given answered in the handwritten format in brief explanation.
Q: !Consider the following table Policy No. Agreement No. Work_Hours Worker_Name Restaurant_Number…
A: i provide the answer below
Q: The relationship between marketing expenditures (x) and sales (y) is given by the following formula,…
A: a) Given equation y = 8x - 0.20x^2 + 6 --- (a) here differentiation of equation a" with respective…
Q: EMPNO ENAME JOB M...Y HIREDATE SAL t COMM DEPTNO 1 7521 WARD 2 7654 MARTIN SALESMAN 7698 28-SEP-81…
A: I have written the query below:
Q: Teddy Bower is an outdoor clothing and accessories chain that purchases a line of parkas at $10 each…
A: Complete answer is given below .
Q: Q3 Consider the following table Policy No. Agreement No. Work_Hours Worker_Name Restaurant_Number…
A: ANSWER: The given table is present in UNF so make it normalized by creating the Primary key in the…
Q: • The following table (Training Dataset D) shows the midterm and final exam grades obtained for…
A: Note: As you have asked a multipart question, as per our policy, we will solve the first three parts…
Q: 1- Suppose you have the information of sales (la) of poultry factory (elgall Jasza) ,contain several…
A: Required: excel
Q: for the various item types. Item Type January February March April May June Cosmetics 8723.19…
A: According to the question , we have to write a program which accepts as inputs the above sales…
Q: Q1. A shop owner has 2 outlets namely a High Street Branch and Mall Branch, befi 19 lockdown the…
A: Given the high street Branch and Mall branch we have to to write the java programe to calculate of…
Q: Considering the following tables,. is a foreign ke Student Table SID Name Expected Graduation 123…
A: To know which among these is the foreign key we have to understand first what is foreign key…
Q: [Question-2] Use a one-dimer salespeople on a their gross sales f week receives $20
A: Code: using System; namespace ConsoleApplication11 { internal class Program {…
Q: Using C. This question deals with processing the semi-annual sales for a drug store. The drug store…
A: Source Code in C++ #include <iostream>#include <string>#include <limits> using…
Q: Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL…
A: count() returns the number of records that are present
Q: Normalize the following table, given 1NF, 2NF and BCNF: Students School Group А, В Subject Name 1st…
A: answer is
Q: A big retailer company is trying to determine the number of salespeople it should allocate to its…
A: 1. Calculate your monthly sales goal. If you’re setting personal sales goals or team goals, they…
Q: Each publication of an academic can be cited from other publications. To this academic The h-index…
A: Input : N = Number of article Citation array of size = N Output : h - index value calculated…
Q: Construct a Pareto chart for the data. What is the relative frequency for the preference of sausage?…
A:
Q: The gasoline price often varies a great deal across different regions across country X. The…
A:
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images
- A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid19 lockdown the respective shops recorded sales as follows: High Street Branch Quarter Sales Q1 42,000 48,000 50,000 Q2 52,000 58,000 60,000 Q3 46,000 49,000 58,000 Q4 50,000 51,000 61,000 Mall Branch Quarter Sales Q1 57,000 63,000 60,000 Q2 70,000 67,000 72,000 Q3 67,000 65,000 62,000 Q4 72,000 69,000 75,000 As a programmer hired by the shops’ owner, write a java program to calculate: (a) the monthly combine sales figures for both shops; (b) the respective shops annual sales figures; (c) the grand annual combine total sales figures. Note: Your program must be implemented with arrays.A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid19 lockdown the respective shops recorded sales as follows: High Street Branch Quarter SalesQ1 42,000 48,000 50,000Q2 52,000 58,000 60,000Q3 46,000 49,000 58,000Q4 50,000 51,000 61,000 Mall Branch Quarter SalesQ1 57,000 63,000 60,000Q2 70,000 67,000 72,000Q3 67,000 65,000 62,000Q4 72,000 69,000 75,000 As a programmer hired by the shops’ owner, write a java program to calculate: (a) the monthly combine sales figures for both shops; (b) the respective shops annual sales figures; (c) the grand…A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid-19 lockdown the respective shops recorded sales as follows: high stree branch Quarter sales sales sales Q1 42,000 48,000 50,000 Q2 52,000 58,000 60,000 Q3 46,000 49,000 58,000 Q4 50,000 51,000 61,000 Mall Branch Quarter Q1 57,000 63,000 60,000 Q2 70,000 67,000 72,000 Q3 67,000 65,000 62,000 Q4 72,000 69,000 75,000 As a programmer hired by the shops’ owner, write a java program to calculate: (a) the monthly combine sales figures for both shops; (b) the respective shops annual sales figures; (c) the grand annual combine total sales figures. Note: Your program must be implemented with arrays.
- <ul> - `bsal` = beginning salary (annual salary at time of hire) - `sal77` = annual salary in 1977 - `sex` = MALE or FEMALE - `senior` = months since hired - `age` = age in months - `educ` = years of education - `exper` = months of prior work experience </ul> banksalary.csv bsal,sal77,sex,senior,age,educ,exper 5040,12420,MALE,96,329,15,14 6300,12060,MALE,82,357,15,72 6000,15120,MALE,67,315,15,35.5 6000,16320.00098,MALE,97,354,12,24 6000,12300,MALE,66,351,12,56 6840,10380,MALE,92,374,15,41.5 8100,13979.99902,MALE,66,369,16,54.5 6000,10140,MALE,82,363,12,32 6000,12360,MALE,88,555,12,252 6900,10920,MALE,75,416,15,132 6900,10920,MALE,89,481,12,175 5400,12660.00098,MALE,91,331,15,17.5 6000,12960,MALE,66,355,15,64 6000,12360,MALE,86,348,15,25 5100,8940,FEMALE,95,640,15,165 4800,8580,FEMALE,98,774,12,381 5280,8760,FEMALE,98,557,8,190 5280,8040,FEMALE,88,745,8,90 4800,9000,FEMALE,77,505,12,63 4800,8820,FEMALE,76,482,12,6 5400,13320,FEMALE,86,329,15,24 5520,9600,FEMALE,82,558,12,97…<ul> - `bsal` = beginning salary (annual salary at time of hire) - `sal77` = annual salary in 1977 - `sex` = MALE or FEMALE - `senior` = months since hired - `age` = age in months - `educ` = years of education - `exper` = months of prior work experience </ul> banksalary.csv bsal,sal77,sex,senior,age,educ,exper 5040,12420,MALE,96,329,15,14 6300,12060,MALE,82,357,15,72 6000,15120,MALE,67,315,15,35.5 6000,16320.00098,MALE,97,354,12,24 6000,12300,MALE,66,351,12,56 6840,10380,MALE,92,374,15,41.5 8100,13979.99902,MALE,66,369,16,54.5 6000,10140,MALE,82,363,12,32 6000,12360,MALE,88,555,12,252 6900,10920,MALE,75,416,15,132 6900,10920,MALE,89,481,12,175 5400,12660.00098,MALE,91,331,15,17.5 6000,12960,MALE,66,355,15,64 6000,12360,MALE,86,348,15,25 5100,8940,FEMALE,95,640,15,165 4800,8580,FEMALE,98,774,12,381 5280,8760,FEMALE,98,557,8,190 5280,8040,FEMALE,88,745,8,90 4800,9000,FEMALE,77,505,12,63 4800,8820,FEMALE,76,482,12,6 5400,13320,FEMALE,86,329,15,24 5520,9600,FEMALE,82,558,12,97…<ul> - `bsal` = beginning salary (annual salary at time of hire) - `sal77` = annual salary in 1977 - `sex` = MALE or FEMALE - `senior` = months since hired - `age` = age in months - `educ` = years of education - `exper` = months of prior work experience </ul> banksalary.csv bsal,sal77,sex,senior,age,educ,exper 5040,12420,MALE,96,329,15,14 6300,12060,MALE,82,357,15,72 6000,15120,MALE,67,315,15,35.5 6000,16320.00098,MALE,97,354,12,24 6000,12300,MALE,66,351,12,56 6840,10380,MALE,92,374,15,41.5 8100,13979.99902,MALE,66,369,16,54.5 6000,10140,MALE,82,363,12,32 6000,12360,MALE,88,555,12,252 6900,10920,MALE,75,416,15,132 6900,10920,MALE,89,481,12,175 5400,12660.00098,MALE,91,331,15,17.5 6000,12960,MALE,66,355,15,64 6000,12360,MALE,86,348,15,25 5100,8940,FEMALE,95,640,15,165 4800,8580,FEMALE,98,774,12,381 5280,8760,FEMALE,98,557,8,190 5280,8040,FEMALE,88,745,8,90 4800,9000,FEMALE,77,505,12,63 4800,8820,FEMALE,76,482,12,6 5400,13320,FEMALE,86,329,15,24 5520,9600,FEMALE,82,558,12,97…
- Let Tran1,Tran2 & Tran3 be three independent transactions. Where Tran1 transfers the one fourth of the A accounts fund to B account. Tran2 updates the balance of the B account by 32% & Tran3 transaction provides two third of the prior balance of the A account (before providing funds to B account) to the charity account. Now write down the concurrent transactions according to the serial given above.Calculate the Theil index and the Atkinson index (use = 1) of house-hold income for all households and by race (in other words, calculate the inequality measures within racial categories). what would be the code for the above question in stata?Question 2:In the University library every 5 minutes a student arrives arrives. The librarian takes 3 minutesto serve student. Complete the following table (for 10 students) and calculate the averagetime a student spends in the system, arrival rate, service rate and percentage idle time of server.(Assume the first student arrives at 8:00 A.M and service begin immediately).
- 9. The table P2.1 shows the number of paid transactions on the website during the period 2012 to 2020. (i) In cell E70, write a formula using RRI function to compute the Compounded Annual Growth Rate (CAGR) for the period 2012 to 2020.Every campus has full time students who attend classes between 8h00 and 17h00 during theweek. Every campus also has part time students who attend classes between 18h00 and 21h00 onweekdays. In the scenario provided at the beginning of Q.1.1, it is stated that no student shouldbe allowed to access the campus after 12h00. The campus has decided to change this rule to state“no full-time student will be allowed to access the campus after 12h00. Part time students canaccess the campus as from 17h00 By making use of a class diagram, demonstrate how the concept of inheritancecan be used to represent the scenario provided at the beginning of thisquestion. Marks will be awarded as follow: Class diagram showing inheritance; Attributes; Instance methods; Access specifiersProblem 20.c Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers: CUST_LNAME CUST_FNAME CUST_BALANCE Smith Jeanne 1050.11 Ortega Juan 840.92