Muscat marketing research company is conducting a rating survey of different chains of supermarkets.The rating is over 5 stars (*****), a Text file is provided with two columns, one holds the name ofsupermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets aboutwhom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get ** means it haspoints.sum of points of each market /number of times rated.got2Amarketisratedmorethanonce,sotheformulaeisNote: Program solution must use functions and arrays only.Download rating.txt from moodle.Rating.txt is containing 100 records, so you may declare array size as 100 as a global variable.Sample Text fileAuchanCarrefourrating.txt xAuchan***GeantCarrefour車末**Geant**HyperPandaHyperPandaLuluLuluLulu*********SpinneysSpinneysArwani Stores****ArwaniTalalTalalMadinaAuchanMadinatCarrefour****Geant**HyperPandaLulu*****Lulu*****Input (): A void function receives two arrays to read data from the file rating.txt, string array holds thenames of the supermarkets and an integer array holds the points, and count variable with reference getsthe number of records added from file to array.Process (): A void computes and prints the rating for each supermarket by adding all its points thendividing by number of times it has been rated.Sample Output:CAWindowssystem32cmd.exeNameNo Times RatedRating==== ==== =====-=== ===-= ===Auchan|CarrefourGeantHyperPandaLuluSpinneysArwaniTalalMadinaPress any key to continue3.444.223.00113.27224.55122.92103.50103.7083.38

Muscat marketing research company is conducting a rating survey of different chains of supermarkets. The rating is over 5 stars (*****), a Text file is provided with two columns, one holds the name of supermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets about whom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get ** means it has got points. A market is rated more than once, so the formulae is sum of points of each market /number of times rated.

Muscat marketing research company is conducting a rating survey of different chains of supermarkets. The rating is over 5 stars (***), a Text file is provided with two columns, one holds the name of supermarkets and the other column holds rating in stars. Find the list below of 9 supermarkets about whom rating is being conducted. Each star is equal to 1 point. Suppose a supermarket get means it has got points. A market is rated more than once, so the formulae is sum of points of each market /number of times rated.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 11RA

See similar textbooks

Similar questions

The file named Ch21p1.xlsx contains data about unit sales for 11 products during the years1999–2003. Write a formula using the MATCH and OFFSET functions that determines the sales ofa given product during a given year. Can you think of another way to solve this problem without using the MATCH and OFFSET functions?
Polynomial regression is a form of nonlinear regression that describes nonlinear relationships in a dataset. There are several advantages to linear regression, mainly high accuracy. For your assignment, you will build a polynomial regression model in Python. The data is in a .CSV file that has the following information types. Position Level Salary Business Analyst 1 45000 Junior Consultant 2 50000 Senior Consultant 3 60000 Manager 4 80000 Country Manager 5 110000 Region Manager 6 150000 Partner 7 200000 Senior Partner 8 300000 C-level 9 500000 CEO 10 1000000 Using this data, our model should be able to predict the value of an employee candidate given their years of experience. The Python file must demonstrate the prediction of employee salary based on years of experience.
Using Pandas library in python - Calculate student grades project Pandas is a data analysis library built in Python. Pandas can be used in a Python script, a Jupyter Notebook, or even as part of a web application. In this pandas project, you’re going to create a Python script that loads grade data of 5 to 10 students (a .csv file) and calculates their letter grades in the course. The CSV file contains 5 column students' names, score in-class participation (5% of final grade), score in assignments (20% of final grade), score in discussions (20% of final grade), score in the mid term (20% of final grade), score in final (25% of final grade). Create the .csv file as part of the project submission Program Output This will happen when the program runs Enter the CSV file Student 1 named Brian Tomas has a letter grade of B+ Student 2 named Tom Blank has a letter grade of C Student 3 named Margo True has a letter grade of A Student 4 named David Atkin has a letter grade of B+ Student 5 named…
using python in jupyter notebook; we were given a csv file called stolen_animals.csv which contained data on stolen animals in london . The original raw data was given like this; Count of Stolen Animals,Type of Animal,Borough,Type Of Offence,Animal Recovered,Year and Month1,Dog,Lambeth,Theft and Handling,Not Recovered,Jan-20101,Dog,Islington,Violence Against the Person,Not Recovered,Jan-2010 but have written a function which made each column into list, count of stolen animals into a list of integers and the rest into list of integers. I now need to create functions to find the average number of stolen animals and another to get a list of unique types of animals that have been stolen. To add we are not allowed to use packages and can only input/output to be done by open and close. Below is the specifications given for each function
You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…
A data set has 4 columns--index, CUSTOMER_EMAIL, Net Revenue, and Year. For each year we need the following information: New Customer Revenue e.g., new customers not present in previous year only Lost Customers New Customers Total Customers Previous Year Total Customers Current Year Please implement it using python.
The GTUC Company wants to produce a product orders report from its product orders file. Each record on the file contains the product number of the item ordered, the product description, the number of units ordered, the retail price per unit, the freight charges per unit, and the packaging costs per unit. Your algorithm is to read the product orders file, calculate the total amount due for each product ordered and print these details on the product orders report.The amount due for each product is calculated as the product of the number of units ordered and the retail price of the unit. A discount of 10% is allowed on the amount due for all orders over 100.00. The freight charges and packaging costs per unit must be added to this resulting value to determine the total amount due.
Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 Suppose that STU_CODE is the student code (foreign key) and CLS_CODE is the class code (foreign key). Which of the following computes the average for each year of the student with code 931? a. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY YEAR b. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931. c. SELECT AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE = 931 d. SELECT AVG(GRADE) FROM STUGRADE WHERE STU_CODE = 931 GROUP BY AVG(GRADE)
Use import sys. Use the german_credit_data.csv file to complete the following assignment. Create a file, german.py, that loads the .csv file and runs a regression predicting credit amount from age and duration, in that order. Add a constant using sm.add_constant(data). You will need to rename the column 'Credit amount' and should change it to 'Credit_amount'. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. Then, print the parameters and R-squared to 2 decimals using print(model.params.round(2)) print(model.rsquared.round(2))
The chr21_genes.txt file lists genes from human chromosome 21, in their order along the chromosome, as described in Hattori et al. (Nature 405, 311-319) (Links to an external site.). For each gene, the file gives the gene symbol, description and category. The fields are separated by tabs. You will need to get the the meaning of each category. You can find these meanings in the original paper (Links to an external site.), under the "Gene categories" section. Create a file named chr21_genes_categories.txt that store this information in tab separated fields:
A basic wooden railway set contains the pieces shown in figure below. It identifies the quantityof each type of piece denoted by ‘x’. Each piece is not uniquely identified by a primary keyvalue only labeled by type. i.e., Input information only states quantity of types such as twelvestraight pieces, two branch pieces, two merge pieces, and sixteen curve pieces. Pieces connect the knob to opening, with subtend curves extending the arc from start to end by45 degrees, and the pieces can be flipped over for track direction. The task is to connect these pieces into a railway that has no overlapping tracks and no looseends where a train could run off onto the floor. Question: Suppose that the pieces fit together exactly with no slack. Give a precise formulation of thetask as a search problem. Write a Java algorithm to assemble optimally solving the problem.
a. Software Engineering Research Group (SERG) IIUM is organizing a programming competition. Students are allowed to use either Python or C++ programming language for the competition. Student who wishes to opt for Python goes into lab 1 while for C++ in lab 2. The seating arrangement is based on question ID. The number of students that registered for the competition are 10 students only. Each lab has capacity of 13 students. You are required to create a hash table to indicate where each student with the following question IDs (keys) be hashed/mapped to in the slot of the lab (hash table). IDs = {41, 28, 54, 18, 36, 10, 90, 12, 38, 25} using the hash function, h1(ID) = (ID) % lab capacity Show all your calculations and indication to where the values are being hashed.