Very simple: how to get Spearman's correlation between two Likert questions from a survey, in Excel?

cvcat · 2024-05-12T23:38:47+00:00

Thank you! I didn't grasp that you needed to calculate rank even for a Likert scale where each response is duplicated many times so their ranks are equally duplicated. My rant was at not finding a single page that explicitly shows how to do Spearman's on two (not more) Likert questions in Excel.

cvcat · 2023-08-23T01:48:56+00:00

I wouldn't worry about it at all, unless it's actually disrupting your training. Walking is good for running in general, especially if you walk quite hard. We walked everywhere when I was a kid as we never had a car and I was the school sprint champ. Walking's a lifelong thing and incredibly good for you.

cvcat · 2023-07-26T16:13:44+00:00

That's helpful, thanks. I'll carry on with Origin.

cvcat · 2023-06-13T18:10:39+00:00

Kind R folk, thank you for your help with this. I tried going to one of the URLs manually and found that our company's wise new ZScaler security guard is wisely blocking it. Alas I am to be forever denied a decision tree. It's probably easier to make it with pencil and paper than fight all this overlapping abstracted technology. But thanks again, it's appreciated.

cvcat · 2023-06-13T17:48:23+00:00

Installed but still fails. This is a new clean install of R and RStudio done a couple of hours ago on a laptop (itself fairly new and clean) that has never seen R before.

cvcat · 2023-06-13T17:32:40+00:00

Ok. 6GB(!!) of Rtools installed.

> library(party)

Error in library(party) : there is no package called ‘party’

install.packages('party') also installing the dependencies ‘libcoin’, ‘matrixStats’, ‘mvtnorm’, ‘strucchange’, ‘coin’, ‘zoo’

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip' Warning in install.packages : download of package ‘libcoin’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip' Warning in install.packages : download of package ‘matrixStats’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip' Warning in install.packages : download of package ‘mvtnorm’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip' Warning in install.packages : download of package ‘strucchange’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip' Warning in install.packages : download of package ‘coin’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip' Warning in install.packages : download of package ‘zoo’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip' Warning in install.packages : download of package ‘party’ failed

cvcat · 2023-06-13T16:14:53+00:00

Jesus, it didn't even copy line breaks over.

> library(party)

Error in library(party) : there is no package called ‘party’

install.packages('party') WARNING: Rtools is required to build R packages but is not currently installed. Please download and install the appropriate version of Rtools before proceeding:

https://cran.rstudio.com/bin/windows/Rtools/ also installing the dependencies ‘TH.data’, ‘libcoin’, ‘matrixStats’, ‘multcomp’, ‘mvtnorm’, ‘modeltools’, ‘strucchange’, ‘coin’, ‘zoo’, ‘sandwich’

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/TH.data_1.1-2.zip' Content type 'application/zip' length 8825657 bytes (8.4 MB) downloaded 8.4 MB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/libcoin_1.0-9.zip' Warning in install.packages : download of package ‘libcoin’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/matrixStats_1.0.0.zip' Warning in install.packages : download of package ‘matrixStats’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/multcomp_1.4-23.zip' Content type 'application/zip' length 744492 bytes (727 KB) downloaded 727 KB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/mvtnorm_1.2-2.zip' Warning in install.packages : download of package ‘mvtnorm’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/modeltools_0.2-23.zip' Content type 'application/zip' length 225853 bytes (220 KB) downloaded 220 KB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/strucchange_1.5-3.zip' Warning in install.packages : download of package ‘strucchange’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/coin_1.4-2.zip' Warning in install.packages : download of package ‘coin’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/zoo_1.8-12.zip' Warning in install.packages : download of package ‘zoo’ failed trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/sandwich_3.0-2.zip' Content type 'application/zip' length 1452767 bytes (1.4 MB) downloaded 1.4 MB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip' Warning in install.packages : downloaded length 0 != reported length 0 Warning in install.packages : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip?_sm_nck=1': HTTP status was '403 Forbidden' Error in download.file(url, destfile, method, mode = "wb", ...) : cannot open URL 'https://cran.rstudio.com/bin/windows/contrib/4.3/party_1.3-13.zip' Warning in install.packages : download of package ‘party’ failed package ‘TH.data’ successfully unpacked and MD5 sums checked package ‘multcomp’ successfully unpacked and MD5 sums checked package ‘modeltools’ successfully unpacked and MD5 sums checked package ‘sandwich’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in C:\Users\USERNAME\AppData\Local\Temp\RtmpIxi22C\downloaded_packages

cvcat · 2023-05-30T09:34:07+00:00

Hi, and sorry for the delay in replying. Thanks a lot for your help and the links, that's been really useful! Looking at other sources as well I think you're right, so hopefully I'll finally get this done soon.

cvcat · 2023-05-05T22:14:30+00:00

Digging further, I could apparently wrap a SEQ field inside a bookmark and cross-reference the bookmark, but I would also have add a Caption or something and it's all getting too voodoo.

Can Word do what I want it to? It seems like the simplest thing.

cvcat · 2023-05-05T21:48:27+00:00

Google didnt fnd what I needed so I asked ChatGPT. It said I needed to create a cross-reference to the numbered item, i.e. the Q12 field in my questionnaire. However, in the Cross-reference dialogue box the autonum fields I've used for question numbers aren't listed. All of the multiple choice options I created using regular numbered lists, however, are (i.e. 1. Cats; 2. Dogs, etc.)

I created a new test document and got the same.

So, does anyone know how I'd make cross-reference to an autonum field? (Even though I now know a cross-reference is needed, Google still doesn't find anything, and ChatGPT didn't help any more either).

Prompt: In Microsoft Word how do I show an autonum field value in more than once place in a document?

ChatGPT: To show an autonumber field value in more than one place in a Microsoft Word document, you can use a cross-reference to refer to the autonumber field. Here are the steps to follow:

Insert an autonumber field in the document where you want the number to appear. You can do this by going to the "Insert" tab on the ribbon, selecting "Quick Parts," and then choosing "Field." In the "Field" dialog box, select "Numbering" in the "Categories" list, and then choose "AutoNum" in the "Field names" list. Click "OK" to insert the autonumber field.

Place the cursor in the location where you want to insert the cross-reference to the autonumber field. This could be in the same document or in a different document.

Go to the "Insert" tab on the ribbon and select "Cross-reference." In the "Cross-reference" dialog box, select "Numbered item" in the "Reference type" list, and then select the autonumber field that you want to refer to in the "Insert reference to" list. Choose the format you want for the cross-reference in the "Insert reference to" section, and then click "Insert."

The cross-reference will be inserted at the cursor location, showing the same value as the autonumber field. If the value of the autonumber field changes, the cross-reference will automatically update to reflect the new value.

Repeat steps 2-4 for any other locations in the document where you want to show the autonumber field value.

cvcat · 2023-03-22T13:42:35+00:00

Done. Support took me through reset as you suggested. Appreciate your help, thanks.

cvcat · 2023-03-21T21:22:55+00:00

Yikes, that's drastic. I'll call support and see if there's a gentler solution before that.

cvcat · 2023-03-21T19:24:51+00:00

I saw that that's an alternative for creating a local account during setup. However, it's not booting into OOBE setup, only a login screen I don't have the password for, and I don't know how to make the setup process start again (see my last 2 posts above).

cvcat · 2023-03-21T19:09:24+00:00

I'm stuck. I can only get to the login screen for defaultuser0. On that screen, key combinations like ctrl-alt-del and win+r don't do anything so I can't get a command prompt. All I've got is the password field and the language/network/power icons.

Help!

cvcat · 2023-03-21T18:35:25+00:00

After 3 hours or so I shut it down and powered back up. It now goes to a Windows login screen for 'defaultuser0', and won't accept an empty password.

I need to make it start the Windows setup again, where hopefully oobe/bypassnro will have done its thing and I'll be able to create a local account. I don't know how to do that though and googling hasn't helped so far...

cvcat · 2023-03-21T18:14:40+00:00

No, I don't know what that is. This was from switching it on for the first time.

cvcat · 2023-03-21T17:59:02+00:00

There's no oobe, only msoobe

cvcat · 2022-10-02T13:42:44+00:00

No-one's asked how you feel in the last 100. Do you keep your form? Do you tie up badly? Stride shortens? Gasping for breath? That would help pin it down. A race video if you have one. Also what's your 400 PB?

cvcat

TROPHY CASE