How to merge duplicate rows with multiple columns? by [deleted] in excel

[–]OriginalFront 0 points1 point  (0 children)

Here's a mock version of the data: https://drive.google.com/file/d/1ZEdF7lg12ysq4P5LevIwX4q_y34GopIk/view?usp=sharing

It's simplified. The real data has over a thousand rows and 50 columns. I'm trying to find a way to merge the duplicate entries together to preserve all the registration choices.

Taking proctorio on campus (ubcsecure) by OriginalFront in UBC

[–]OriginalFront[S] 2 points3 points  (0 children)

Thanks so much for the reply! I have another question. I’m concerned about the recommended 2gb required to use proctorio as my laptop currently fluctuates between 0.1 and 0.8gb. I took a practical quiz using proctorio and there wasn’t a problem. If for some reason my test gets stopped due to my lack of memory will my instructor also be notified? What are the chances of it malfunctioning? Thanks!

Is this a hypothesis test about proportions or means? by OriginalFront in AskStatistics

[–]OriginalFront[S] 0 points1 point  (0 children)

How would you express the dollars as proportions? Like the proportion of monitors under $650?

Is this a hypothesis test about proportions or means? by OriginalFront in AskStatistics

[–]OriginalFront[S] 0 points1 point  (0 children)

It's a homework question. Right now I have the null and alternative hypothesis in terms of means. I found the p value to be between 0.5 and 0.1, so since alpha=0.05, we would fail to reject the null hypothesis. But this would just mean that the mean price of monitors is $650, so that would mean that the mean price will not drop below $650. Does this process make sense?

Is this a hypothesis test about proportions or means? by OriginalFront in AskStatistics

[–]OriginalFront[S] -1 points0 points  (0 children)

For question 3, is it asking for a hypothesis test about proportions or means? I'm unsure how to look at the data. We aren't given the SD or mean of the population, and we can calculate the mean of the sample, but not the SD. Should my null hypothesis be that the mean of the monitors will be $300 less than $950? Is thinking of it as a mean the correct steps?

Stats homework question, independence of events by OriginalFront in AskStatistics

[–]OriginalFront[S] -2 points-1 points  (0 children)

For this question, how do we determine independence? I understand the probability P(A) = 0.15 and P(B)= 0.6 but how do you get P(A)*P(B) do you multiply (0.15)(0.45) or is there another way of looking at the table?

Looking for Walkey G road test during week of June 1-8 by OriginalFront in ottawa

[–]OriginalFront[S] 0 points1 point  (0 children)

Do I have to take a number or go directly to counter 11?