PRACTICAL EXERCISE 1.2Enter the data given below into a worksheet.EStationerySupplies Ltd2.ReceiptAmountDateSalesPerson ItemNoToysStationeryToys1238 1,782.101255 4,853.5551.3521-NovCarl26-NovCarlCarl139526-NovCarl'sTotal114191.16Cards21-Nov24-Nov10 21-NovJohnJohnJohn1982442.60Books9561.5062.751885ToysToys18751126-NovJohnJohn'sTotal12234.50472.601032JudyJudyBooks13 22-Nov14 26-Nov1920SportsgoodsJudy'sTotal1516 25-NovMaryToys1774364.15Mary'sTotal1752.9581.60116018 22-Nov19 23-NovSusanSusanElectronicsCardsOthers10751745132.9520 23-NovSusan1662 2,580.10Sportsgoods21 24-NovSusanSusan'sTotal2223GrandTotal24(i). Calculate the totals for each salesperson and get the grand total usinga formula.(ii). Format the worksheet as follows:Make all the Totals bold, two decimal places, comma, center the titleacross columns A-E and make it size 16, bold and Italic.(iii). Put a double border round the whole table and a single line borderinside the table.(iv). Save the worksheet as Stationery Analysis.

Mean can be easily calculated using the following formula in MS Excel: =average(array) Total for…

Answered: PRACTICAL EXERCISE 1.2 Enter the data…

Math

Statistics

PRACTICAL EXERCISE 1.2 Enter the data given below into a worksheet. D E Stationery Supplies Ltd

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: The following table shows deaths due to tuberculosis (TB) in two towns. Complete parts (a) through…

A: Given the data table is

Q: What is the range of the distribution? What are the values of * ** and ***? (i) (ii) (iii) What is…

A: Hey there! Thank you for posting the question. Since your question has more than 3 parts, we are…

Q: Below are two data sets, one for the average retail price of gasoline in the State of California for…

A: Note: Since you have posted a question with multiple subparts, we will solve the first three…

Q: + + + 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 data a Based on the boxplot above, identify the 5…

Q: Data 24 132 156 95 57 173 155 45 134 Question1 xbar Question 2 Question 3 medan median Click to…

A: The xbar for the given data in the question represents the mean of the data.The formula to calculate…

Q: Select all answer that are correct. What is the mode of the following data? 2 2 2 3 3…

A: The mode of a data is given by the number or data value that occurs most frequently. In the given…

Q: Which of the following is an example of qualitative data that can inform data-driven decision…

A: A data consists of the collection of information in the form of a table which can be used for…

Q: 7 and 8. The following data was collected from 1 bag of Hershey Kisses®. Each Kiss® was weighed…

A: Given data: 4.76 4.72 4.74 4.55 4.91 4.74 4.78 4.71 4.80 4.78 4.78 4.75 4.79 4.82 4.91 4.83…

Q: Bar charts are best used for __________ data

A: In this question, We have to tell that for what kind of data we use bar graph.

Q: Does the length of a surgery patient's stay in the hospital depend on the length of time the…

A: Given that: Operative time(x) Length of hospital stay (y) 9 13 6 8 8 15 5 7 10 29 1…

Q: of the Gala below by hand. For all your data points (x₁, yi) you will need to calculate w₁ = ln y₁.…

Q: and then complete parts (a) through (h) below h the video. ants at a 2-year public college were…

A: Given that Histogram We have to determine how many students work between 10 to 14

Q: Price of eggs and milk: The following table presents the average price in dollars for a dozen eggs…

A: Given, the data of the average price in dollars for a dozen eggs and a gallon of milk for each month…

Q: In a clay pigeon shooting competition, hunters enter a tournament where they compete with their…

Q: The data below is the number of hours that people work per week at your job. Construct the…

Q: Country GNP per cap Birth Rate Bangladesh 5200 18 Tanzania 2700 36 Sierra Leone 1770 33…

A: Note : Since you have posted a question with multiple subparts, we will solve the first three…

Q: Provided here is a dataset from a class. This data was collected from an 8-10am course that met…

A: Hi! Thank you for the question, As per the honor code, we are allowed to answer three sub-parts at a…

Q: C. The test-statistic for this data = 14.582 X (Please show your answer to three decimal places.) d.…

A: It is asked to find test statistic for the given data. To find test statistic we'll perform…

Q: Please answer a, b and c.

A: Hello there! There are more than 3 subparts in the question. According to our policies cannot answer…

Q: I conducted a study and asked 15 of my classmates about their daily allowances. Classmate 1 2 3 4 5…

A: Let us formulate a problem out of the given data in the question in the next steps.

Q: Need help with part d-i. Thank you! The following is the data:

A: We have used the excel data analysis tool to run the regression analysis.

Q: Identify the type of data that would be used to describe a response. Length of a spaceship. O…

A: Length of a spaceship is quantitative continuous variable

Q: Consider the following data: 1 1.6 2.9 3. 4.1 4.4 5.8 6.5 7.1 7.2 7.5 y 3. 3.3 4 4.1 4.8 5.4 5.6 5.9…

A: Hi! Thank you for the question, As per the honor code, we are allowed to answer three sub-parts at a…

Q: Please only due problem b & C below as a is already completed. Case managers in a therapeutic…

A: Frequency table is given for risk behaviour and mental health : We have to calculate : 1st : ( %…

Q: Weekly sales of bread at a local Foods Market are given in the table below. Forecast sales for week…

A: Given the weekly sales of bread at a local Foods Market asWeekSales14022385342043825410643273858411

Q: Suppose you are given the following data involving weekly sales and test scores supposedly designed…

A: 2a) From the given data, the following Table can be constructed as: X Y XY X2 Y2 4…

Q: Which of the following is NOT one of IBM's big data characteristics? Variety Velocity Venn diagram…

A: Big data is the data set, which have huge volume that is beyond to perform manual analysis. Such…

Q: Volcano Eruption Data Approximate Number of Eruptions Since 2200 B.C. (unless otherwise indicated)…

A: The data is mainly classified into 2, primary data and secondary data. Primary data is the data that…

Q: Assessment Tasks A. Consider the following data: 77, 89, 76, 90, 78, 83, 83, 82, 85, 94, 94, 78, 84,…

A: We have given that data Sample size n = 20 I want to find percentile. Note:- According to bartleby…

Q: Make a visualization using excel and interpret (show the step by step process in excel)

A: The weekly sales report compares five items- Apparel, Art, Collectibles, Home Décor and Serving. We…

Q: I only need help with question E. Using data set G, answer the questions given below. DATA SET G…

A: e) From the provided information, Sample size (n) = 73 The degree of freedom of this test can be…

Q: Based on the boxplot above, identify the 5 number summary

Q: Open an excel file, and enter the data as follows: The net weights (in grams) of a sample of bottles…

A: Hypothesis testing is a tool for making statistical inferences about the population data. It is an…

Q: llustration 13.7. Construct the cost of living index number for the year 1966 from the following…

Q: 1. Your former high school teacher wants to study if the mean test scores differ among the three…

A: We know that ; Shapiro's test is used for checking Normality. In Shapiro's test there are two…

Q: Which data set has a larger variation? (justify your answer)

A: A) Variation is basically measured by variance or standard deviation. For, the figure we can easily…

Q: Please use the accompanying Excel data set or accompanying Text file data set when completing the…

Q: The statistics that describe a population in terms of personal characteristics.

A: Statistics that describe a population in terms of personal characteristics such as age, gender,…

Q: We'll look at the Galton data frame from the mosaicData package: data(Galton) View(Galton)…

A: R-code for scatterplot ############ library(mosaicData)#loading…

Q: Data Frequency 50 - 54 13 55 - 59 21 60 - 64 11 65 - 69 11 70 - 74 8 75 - 79 4 80 - 84 85 - 89 2 90…

A: We want to find the central value (mean, median and mode)

Q: Background information: Allison collected additional days of data to monitor the process. Steps to…

A: The following formulas are required for the Xbar chart and R chart.Xbar chart:…

Q: The following data was collected from 1 bag of Hershey Kisses®. Each Kiss® was weighed in grams with…

A: Solution as below:

Q: Make a visualization using excel and interpret (show the step by step process in excel)

A: The data has five categories which are compared over two time periods- 1910 and 2003. The best…

Concept explainers

Correlation

Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.

Linear Correlation

A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.

Regression Analysis

Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.

Question

PRACTICAL EXERCISE 1.2
Enter the data given below into a worksheet.
E
Stationery
Supplies Ltd
2.
Receipt
Amount
Date
SalesPerson Item
No
Toys
Stationery
Toys
1238 1,782.10
1255 4,853.55
51.35
21-Nov
Carl
26-Nov
Carl
Carl
1395
26-Nov
Carl's
Total
1141
91.16
Cards
21-Nov
24-Nov
10 21-Nov
John
John
John
1982
442.60
Books
9
561.50
62.75
1885
Toys
Toys
1875
11
26-Nov
John
John's
Total
12
234.50
472.60
1032
Judy
Judy
Books
13 22-Nov
14 26-Nov
1920
Sports
goods
Judy's
Total
15
16 25-Nov
Mary
Toys
1774
364.15
Mary's
Total
17
52.95
81.60
1160
18 22-Nov
19 23-Nov
Susan
Susan
Electronics
Cards
Others
1075
1745
132.95
20 23-Nov
Susan
1662 2,580.10
Sports
goods
21 24-Nov
Susan
Susan's
Total
22
23
Grand
Total
24
(i). Calculate the totals for each salesperson and get the grand total using
a formula.
(ii). Format the worksheet as follows:
Make all the Totals bold, two decimal places, comma, center the title
across columns A-E and make it size 16, bold and Italic.
(iii). Put a double border round the whole table and a single line border
inside the table.
(iv). Save the worksheet as Stationery Analysis.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

A high school teacher at a small private school assigns trigonometry practice problems to be worked on via the net. Students must use a password to access the problems, and the time of log-in and log-off is automatically recorded for the teacher. At the end of the week, the teacher examines the amount of time each student spent working on the assigned problems. The data is provided below in minutes. Determine Mean, Median and Mode. 15 28 25 48 22 43 49 34 22 33 27 25 22 20 39
The accompanying data table contains the prices and weights of the diamonds in 10 rings offered for sale. The prices are 4 carats an Xough d belo Data (Daund both The weight in carats and price in dollars for 10 diamond rings Weight 0.29 0.32 0.34 0.17 0.36 0.36 0.12 0.14 0.23 0.26 Price 924 881 1,039 445 1,073 1,034 120 320 665 733 Print Done - rings. ble.
Part 1 of 4 Does the length of a surgery patient's stay in the hospital depend on the length of time the operation took? The table below gives the operative time (in hours) and the length of the hospital stay (in days) for 10 patients. (Comma separated lists of the data are also provided below the table to ease in copying the data to R.) Operative Time (x) Length of Hospital Stay (y) 5 13 13 12 12 14 17 4 12 3 12 7 15 3 x: 5, 5, 5, 2, 6, 5, 4, 3, 7, 3 y: 13, 13, 12, 12, 14, 17, 12, 12, 15, 7 Conduct a hypothesis test with a 5% level of significance to determine whether or not the operative time and the length of a patient's hospital stay are correlated. Step 1: State the null and alternative hypotheses. Ho:p = test.) (So we will be performing a two-tailed O Rost to forum
Please answer this question
Provided here is a dataset from a class. This data was collected from an 8-10am course that met every Tuesday and Thursday. Answer all of the following questions. Give your answers in sentences and/or copy/paste your Excel graphs/commands when used. 2019 Data Gender Age Height (in) Shoe Size Miles Home to school Classes this Semester M 20 77 15 3 4 F 45 63 11 8 3 F 20 62 8.5 22 4 F 19 68 9 7.5 4 M 19 70 9.5 6.5 4 F 18 63 6.5 6.5 5 F 21 62 5.5 2 4 F 19 65 7 7 4 F 18 64 8.5 5.5 5 F 19 60 7 15 3 F 21 60 6.5 5 1 M 19 72 11 15 5 M 42 68.75 11 5 1 M 18 74 11.5 2.5 4 F 18 62 6.5 7.5 4 F 19 60 7.5 3 5 F 20 59 4.5 3.5 5 M 20 78 14 87 5 M 19 72.5 12 0.5 4 M 21 66 8.5 5 4 M 19 76 12 45 5 M 19 71 12 22 5 M 19 69 11 4.5 4 F 19 65 7 2 4 F 25 66 8 1 2 M 19 68 10 5 4 M 19 72 11.5 82 4 F 18 64 8.5 21 4 F 23 70 9.5 4 3 D) Find the mean and standard deviation of the heights of this sample of students. E) The Empirical Rule…
The variable week# is at what level of measurement
Please answer all, will upvote your answer
SHORT QUIZ Complete the following table using the data below. Area 50 3.5 1.20 48 36 4.8 3 83 75 1.90 48 -2.00 67 25 1.20 on
Compute the coefficient of determination. Round the answer to at least three decimal places. The coefficient of determination is…
See question attached
II. Enumeration. 1. 5 Examples of Qualitative Data 2. 5 Examples of Quantitative Data 3. 5 Examples of Discrete Data 4. 5 Examples of Continuous Data
part (B)